PREVIEW / stock_30min / 2010-05-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-05.parquet
  size:    1.5 MB
  rows:    78,840
  symbols: 3,481

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-05-05 04:00:00	AAPL	Stock	9.1536	9.1679	9.1536	9.1679	8400.0
2010-05-05 04:30:00	AAPL	Stock	9.1671	9.1675	9.1393	9.1393	14000.0
2010-05-05 05:00:00	AAPL	Stock	9.1679	9.175	9.1679	9.175	14924.0
2010-05-05 05:30:00	AAPL	Stock	9.2057	9.2168	9.2057	9.2057	115948.0
2010-05-05 06:00:00	AAPL	Stock	9.2007	9.2007	9.2007	9.2007	2800.0
2010-05-05 06:30:00	AAPL	Stock	9.2032	9.2032	9.2032	9.2032	27720.0
2010-05-05 07:00:00	AAPL	Stock	9.1929	9.2089	9.1818	9.1918	80024.0
2010-05-05 07:30:00	AAPL	Stock	9.1875	9.1996	9.1786	9.1929	281540.0
2010-05-05 08:00:00	AAPL	Stock	9.1911	9.2	9.1125	9.125	2638748.0
2010-05-05 08:30:00	AAPL	Stock	9.125	9.1339	9.0593	9.0696	4719456.0
2010-05-05 09:00:00	AAPL	Stock	9.0679	9.07	9.0314	9.0321	7405944.0
2010-05-05 09:30:00	AAPL	Stock	9.0361	9.0389	8.8832	8.9807	203765688.0
2010-05-05 10:00:00	AAPL	Stock	8.9807	9.0482	8.9518	9.0055	120796340.0
2010-05-05 10:30:00	AAPL	Stock	9.0032	9.1314	9.0021	9.1025	80612672.0
2010-05-05 11:00:00	AAPL	Stock	9.1043	9.1593	9.0518	9.1286	55295268.0
2010-05-05 11:30:00	AAPL	Stock	9.1314	9.2079	9.12	9.2043	40036220.0
2010-05-05 12:00:00	AAPL	Stock	9.2014	9.2193	9.1114	9.1189	49063280.0
2010-05-05 12:30:00	AAPL	Stock	9.1185	9.1504	9.085	9.1246	30529548.0
2010-05-05 13:00:00	AAPL	Stock	9.1229	9.166	9.1143	9.1468	22977360.0
2010-05-05 13:30:00	AAPL	Stock	9.1468	9.1729	9.1279	9.1471	23546964.0
2010-05-05 14:00:00	AAPL	Stock	9.1454	9.1607	9.1161	9.1215	32987668.0
2010-05-05 14:30:00	AAPL	Stock	9.1232	9.1239	9.0471	9.11	49822640.0
2010-05-05 15:00:00	AAPL	Stock	9.1075	9.1246	9.0743	9.1036	34611696.0
2010-05-05 15:30:00	AAPL	Stock	9.1039	9.1511	9.0546	9.1471	66266284.0
2010-05-05 16:00:00	AAPL	Stock	9.1493	9.1493	8.6643	9.1286	8531488.0
2010-05-05 16:30:00	AAPL	Stock	9.1286	9.1418	9.0968	9.1214	927276.0
2010-05-05 17:00:00	AAPL	Stock	9.1196	9.1321	9.115	9.1321	174580.0
2010-05-05 17:30:00	AAPL	Stock	9.1339	9.1429	9.1339	9.1393	206220.0
2010-05-05 18:00:00	AAPL	Stock	9.1379	9.1482	9.1379	9.1429	587860.0
2010-05-05 18:30:00	AAPL	Stock	9.1296	9.1482	9.1293	9.1475	105616.0
2010-05-05 19:00:00	AAPL	Stock	9.1475	9.1546	9.1432	9.1518	216412.0
2010-05-05 19:30:00	AAPL	Stock	9.1504	9.1554	9.1429	9.1464	301784.0
2010-05-05 20:00:00	AAPL	Stock	9.1446	9.1446	9.1446	9.1446	210000.0
2010-05-05 07:00:00	MSFT	Stock	29.86	29.96	29.86	29.96	3500.0
2010-05-05 07:30:00	MSFT	Stock	29.96	29.96	29.91	29.94	1520.0
2010-05-05 08:00:00	MSFT	Stock	29.96	29.96	29.9	29.91	18291.0
2010-05-05 08:30:00	MSFT	Stock	29.93	29.99	29.91	29.93	32581.0
2010-05-05 09:00:00	MSFT	Stock	29.93	29.93	29.76	29.77	103894.0
2010-05-05 09:30:00	MSFT	Stock	29.76	30.09	29.69	29.88	8043702.0
2010-05-05 10:00:00	MSFT	Stock	29.87	29.99	29.85	29.91	7291637.0
2010-05-05 10:30:00	MSFT	Stock	29.92	30.04	29.904	29.985	5285304.0
2010-05-05 11:00:00	MSFT	Stock	29.985	30.0	29.92	29.96	4511725.0
2010-05-05 11:30:00	MSFT	Stock	29.968	29.98	29.94	29.958	3843559.0
2010-05-05 12:00:00	MSFT	Stock	29.96	29.97	29.86	29.884	3783707.0
2010-05-05 12:30:00	MSFT	Stock	29.89	29.93	29.87	29.93	3222766.0
2010-05-05 13:00:00	MSFT	Stock	29.93	29.94	29.88	29.91	2465312.0
2010-05-05 13:30:00	MSFT	Stock	29.9	29.97	29.88	29.92	3218942.0
2010-05-05 14:00:00	MSFT	Stock	29.93	29.93	29.885	29.91	2985155.0
2010-05-05 14:30:00	MSFT	Stock	29.9	29.92	29.83	29.83	5816818.0
2010-05-05 15:00:00	MSFT	Stock	29.835	29.85	29.76	29.82	5055237.0

> showing 50 of 78,840 rows — these rows as CSV

> unlock the full archive -- $79 one-time