PREVIEW / stock_30min / 2017-03-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-09.parquet
  size:    1.6 MB
  rows:    82,844
  symbols: 3,091

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
2017-03-09 04:00:00	AAPL	Stock	34.81	34.8275	34.81	34.825	2696.0
2017-03-09 05:00:00	AAPL	Stock	34.7625	34.7625	34.7575	34.7575	2356.0
2017-03-09 06:00:00	AAPL	Stock	34.6775	34.6775	34.665	34.665	5860.0
2017-03-09 06:30:00	AAPL	Stock	34.675	34.675	34.6425	34.6475	10632.0
2017-03-09 07:00:00	AAPL	Stock	34.675	34.675	34.6325	34.65	63904.0
2017-03-09 07:30:00	AAPL	Stock	34.65	34.6725	34.65	34.6525	15488.0
2017-03-09 08:00:00	AAPL	Stock	34.65	34.6725	34.605	34.625	220224.0
2017-03-09 08:30:00	AAPL	Stock	34.6175	34.705	34.615	34.7	184576.0
2017-03-09 09:00:00	AAPL	Stock	34.7	34.7025	34.6575	34.685	128588.0
2017-03-09 09:30:00	AAPL	Stock	34.685	34.6975	34.2625	34.61	22575444.0
2017-03-09 10:00:00	AAPL	Stock	34.6075	34.6788	34.5875	34.6175	7254752.0
2017-03-09 10:30:00	AAPL	Stock	34.6188	34.675	34.6	34.6612	4195748.0
2017-03-09 11:00:00	AAPL	Stock	34.6612	34.685	34.6375	34.65	3112164.0
2017-03-09 11:30:00	AAPL	Stock	34.65	34.6675	34.6295	34.655	2300788.0
2017-03-09 12:00:00	AAPL	Stock	34.655	34.6638	34.6075	34.62	2172424.0
2017-03-09 12:30:00	AAPL	Stock	34.6188	34.6425	34.5875	34.6275	1975412.0
2017-03-09 13:00:00	AAPL	Stock	34.6287	34.6425	34.605	34.6062	1318696.0
2017-03-09 13:30:00	AAPL	Stock	34.6075	34.6088	34.56	34.5772	3238328.0
2017-03-09 14:00:00	AAPL	Stock	34.5775	34.58	34.45	34.5275	5233060.0
2017-03-09 14:30:00	AAPL	Stock	34.5288	34.5725	34.47	34.57	3941084.0
2017-03-09 15:00:00	AAPL	Stock	34.57	34.6475	34.5675	34.62	4435872.0
2017-03-09 15:30:00	AAPL	Stock	34.62	34.6725	34.6188	34.67	6771476.0
2017-03-09 16:00:00	AAPL	Stock	34.67	34.67	34.6525	34.67	10422192.0
2017-03-09 16:30:00	AAPL	Stock	34.67	34.6775	34.66	34.6625	114496.0
2017-03-09 17:00:00	AAPL	Stock	34.68	34.68	34.6625	34.6625	10760.0
2017-03-09 17:30:00	AAPL	Stock	34.67	34.675	34.67	34.675	28004.0
2017-03-09 18:00:00	AAPL	Stock	34.6625	34.675	34.6625	34.675	4928.0
2017-03-09 18:30:00	AAPL	Stock	34.68	34.6825	34.675	34.6825	14000.0
2017-03-09 19:00:00	AAPL	Stock	34.685	34.6925	34.685	34.6925	2800.0
2017-03-09 19:30:00	AAPL	Stock	34.7	34.7125	34.7	34.7125	47852.0
2017-03-09 08:00:00	MSFT	Stock	64.88	64.99	64.88	64.99	3099.0
2017-03-09 08:30:00	MSFT	Stock	64.98	65.01	64.98	65.01	3275.0
2017-03-09 09:00:00	MSFT	Stock	64.99	65.2	64.99	65.11	4971.0
2017-03-09 09:30:00	MSFT	Stock	65.19	65.2	64.79	64.94	2922035.0
2017-03-09 10:00:00	MSFT	Stock	64.945	65.0	64.86	64.935	1283553.0
2017-03-09 10:30:00	MSFT	Stock	64.935	65.0	64.87	64.967	1018469.0
2017-03-09 11:00:00	MSFT	Stock	64.965	65.08	64.86	64.95	972859.0
2017-03-09 11:30:00	MSFT	Stock	64.95	64.965	64.88	64.91	666926.0
2017-03-09 12:00:00	MSFT	Stock	64.91	64.95	64.835	64.855	537266.0
2017-03-09 12:30:00	MSFT	Stock	64.855	64.92	64.83	64.86	753756.0
2017-03-09 13:00:00	MSFT	Stock	64.86	64.87	64.71	64.71	616335.0
2017-03-09 13:30:00	MSFT	Stock	64.71	64.72	64.59	64.635	884435.0
2017-03-09 14:00:00	MSFT	Stock	64.635	64.656	64.48	64.58	1343070.0
2017-03-09 14:30:00	MSFT	Stock	64.58	64.616	64.5	64.605	1059416.0
2017-03-09 15:00:00	MSFT	Stock	64.605	64.745	64.6	64.745	1273269.0
2017-03-09 15:30:00	MSFT	Stock	64.746	64.845	64.64	64.74	2442414.0
2017-03-09 16:00:00	MSFT	Stock	64.73	64.73	64.7	64.7	2215431.0
2017-03-09 16:30:00	MSFT	Stock	64.65	64.73	64.65	64.73	36537.0
2017-03-09 17:00:00	MSFT	Stock	64.83	64.83	64.83	64.83	193.0
2017-03-09 18:00:00	MSFT	Stock	64.83	64.83	64.83	64.83	100.0

> showing 50 of 82,844 rows — these rows as CSV

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