PREVIEW / stock_30min / 2012-05-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-17.parquet
  size:    1.5 MB
  rows:    78,961
  symbols: 3,534

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
2012-05-17 04:00:00	AAPL	Stock	19.4532	19.4532	19.4532	19.4532	2800.0
2012-05-17 04:30:00	AAPL	Stock	19.4532	19.4532	19.4532	19.4532	2800.0
2012-05-17 05:30:00	AAPL	Stock	19.4286	19.4286	19.4196	19.4196	5600.0
2012-05-17 06:00:00	AAPL	Stock	19.4393	19.4407	19.4393	19.4407	14000.0
2012-05-17 06:30:00	AAPL	Stock	19.4407	19.4407	19.4107	19.4107	47600.0
2012-05-17 07:00:00	AAPL	Stock	19.4279	19.4643	19.3982	19.4464	264936.0
2012-05-17 07:30:00	AAPL	Stock	19.4314	19.4314	19.3332	19.4054	354592.0
2012-05-17 08:00:00	AAPL	Stock	19.4107	19.4604	19.3611	19.3746	1238272.0
2012-05-17 08:30:00	AAPL	Stock	19.3646	19.5564	19.3446	19.5429	2744448.0
2012-05-17 09:00:00	AAPL	Stock	19.5389	19.5807	19.4646	19.4732	2863532.0
2012-05-17 09:30:00	AAPL	Stock	19.4754	19.5536	19.1804	19.2489	114791236.0
2012-05-17 10:00:00	AAPL	Stock	19.2443	19.3636	19.0961	19.2879	110329408.0
2012-05-17 10:30:00	AAPL	Stock	19.2857	19.3339	19.1864	19.2392	48141268.0
2012-05-17 11:00:00	AAPL	Stock	19.2393	19.2779	19.1325	19.1432	40145168.0
2012-05-17 11:30:00	AAPL	Stock	19.1432	19.1479	19.0429	19.0957	55175148.0
2012-05-17 12:00:00	AAPL	Stock	19.0946	19.1	18.9804	19.0714	47042268.0
2012-05-17 12:30:00	AAPL	Stock	19.0714	19.0929	19.0187	19.0657	28899892.0
2012-05-17 13:00:00	AAPL	Stock	19.0675	19.2279	19.0596	19.1891	48136368.0
2012-05-17 13:30:00	AAPL	Stock	19.1846	19.2268	19.0982	19.1554	24141292.0
2012-05-17 14:00:00	AAPL	Stock	19.15	19.1525	19.02	19.0251	27197968.0
2012-05-17 14:30:00	AAPL	Stock	19.0251	19.0857	19.0089	19.0793	31480092.0
2012-05-17 15:00:00	AAPL	Stock	19.0757	19.1282	19.0029	19.0246	37746520.0
2012-05-17 15:30:00	AAPL	Stock	19.0286	19.0318	18.9329	18.9329	75929700.0
2012-05-17 16:00:00	AAPL	Stock	18.9332	19.1523	18.9329	18.9741	6946184.0
2012-05-17 16:30:00	AAPL	Stock	18.9521	19.2332	18.9329	18.9504	1536752.0
2012-05-17 17:00:00	AAPL	Stock	18.9536	18.9757	18.9329	18.9757	1466416.0
2012-05-17 17:30:00	AAPL	Stock	18.9743	19.0157	18.9714	18.9996	1431696.0
2012-05-17 18:00:00	AAPL	Stock	18.9993	18.9993	18.9714	18.9843	437276.0
2012-05-17 18:30:00	AAPL	Stock	18.9864	18.9921	18.9768	18.9786	123172.0
2012-05-17 19:00:00	AAPL	Stock	18.9818	18.9964	18.9786	18.9889	241388.0
2012-05-17 19:30:00	AAPL	Stock	18.9889	19.0125	18.9771	19.0007	555296.0
2012-05-17 07:00:00	MSFT	Stock	29.88	29.88	29.88	29.88	200.0
2012-05-17 07:30:00	MSFT	Stock	29.8	29.8	29.8	29.8	120.0
2012-05-17 08:00:00	MSFT	Stock	29.9	29.9	29.81	29.86	2717.0
2012-05-17 08:30:00	MSFT	Stock	29.85	30.0	29.85	29.91	9531.0
2012-05-17 09:00:00	MSFT	Stock	29.9	30.0	29.87	29.97	135931.0
2012-05-17 09:30:00	MSFT	Stock	29.99	30.16	29.93	30.14	3669734.0
2012-05-17 10:00:00	MSFT	Stock	30.15	30.208	29.99	30.175	4226849.0
2012-05-17 10:30:00	MSFT	Stock	30.17	30.19	30.0	30.09	2311278.0
2012-05-17 11:00:00	MSFT	Stock	30.09	30.12	29.99	30.006	3006089.0
2012-05-17 11:30:00	MSFT	Stock	30.01	30.04	29.96	29.99	2353300.0
2012-05-17 12:00:00	MSFT	Stock	29.985	30.01	29.89	29.97	2904249.0
2012-05-17 12:30:00	MSFT	Stock	29.971	30.07	29.95	30.019	2415638.0
2012-05-17 13:00:00	MSFT	Stock	30.02	30.09	30.01	30.035	2062621.0
2012-05-17 13:30:00	MSFT	Stock	30.035	30.06	29.94	30.0	1745144.0
2012-05-17 14:00:00	MSFT	Stock	29.995	30.05	29.96	30.0	1947276.0
2012-05-17 14:30:00	MSFT	Stock	30.0	30.02	29.96	30.0	2501470.0
2012-05-17 15:00:00	MSFT	Stock	30.0	30.03	29.92	29.989	3789189.0
2012-05-17 15:30:00	MSFT	Stock	29.99	29.99	29.71	29.73	9853637.0
2012-05-17 16:00:00	MSFT	Stock	29.72	29.979	29.71	29.849	3842057.0

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

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