PREVIEW / stock_30min / 2017-04-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-06.parquet
  size:    1.6 MB
  rows:    82,445
  symbols: 3,049

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-04-06 04:00:00	AAPL	Stock	35.9075	35.925	35.9075	35.92	5552.0
2017-04-06 04:30:00	AAPL	Stock	35.9225	35.9375	35.9225	35.9375	7856.0
2017-04-06 05:30:00	AAPL	Stock	35.965	36.0	35.965	36.0	6268.0
2017-04-06 06:00:00	AAPL	Stock	35.9925	35.9925	35.99	35.99	7600.0
2017-04-06 06:30:00	AAPL	Stock	35.98	36.05	35.98	36.05	33380.0
2017-04-06 07:00:00	AAPL	Stock	36.04	36.06	36.0325	36.0325	42312.0
2017-04-06 07:30:00	AAPL	Stock	36.03	36.0475	36.025	36.025	44400.0
2017-04-06 08:00:00	AAPL	Stock	36.025	36.06	35.9875	36.0125	103552.0
2017-04-06 08:30:00	AAPL	Stock	36.025	36.05	36.005	36.0375	86744.0
2017-04-06 09:00:00	AAPL	Stock	36.0425	36.1	36.0425	36.065	265160.0
2017-04-06 09:30:00	AAPL	Stock	36.0725	36.13	35.955	36.0775	14058844.0
2017-04-06 10:00:00	AAPL	Stock	36.08	36.0975	35.8675	36.015	9153580.0
2017-04-06 10:30:00	AAPL	Stock	36.0125	36.075	35.9442	36.0275	6581688.0
2017-04-06 11:00:00	AAPL	Stock	36.0288	36.0925	36.0055	36.084	3407344.0
2017-04-06 11:30:00	AAPL	Stock	36.0825	36.0875	35.96	36.0178	3636632.0
2017-04-06 12:00:00	AAPL	Stock	36.0225	36.0368	35.9625	36.0125	2563340.0
2017-04-06 12:30:00	AAPL	Stock	36.0125	36.0288	35.9525	35.9775	2252092.0
2017-04-06 13:00:00	AAPL	Stock	35.975	36.075	35.9675	36.0513	2644908.0
2017-04-06 13:30:00	AAPL	Stock	36.05	36.105	36.0175	36.02	2678028.0
2017-04-06 14:00:00	AAPL	Stock	36.0225	36.0425	35.96	35.9725	2927360.0
2017-04-06 14:30:00	AAPL	Stock	35.975	36.01	35.88	35.89	4563696.0
2017-04-06 15:00:00	AAPL	Stock	35.8888	35.9375	35.8775	35.91	3782908.0
2017-04-06 15:30:00	AAPL	Stock	35.9075	35.9675	35.8625	35.9175	10192176.0
2017-04-06 16:00:00	AAPL	Stock	35.915	35.9732	35.9	35.9075	7268472.0
2017-04-06 16:30:00	AAPL	Stock	35.91	35.95	35.9	35.915	35456.0
2017-04-06 17:00:00	AAPL	Stock	35.9375	35.945	35.92	35.945	11812.0
2017-04-06 17:30:00	AAPL	Stock	35.945	35.945	35.915	35.9375	22376.0
2017-04-06 18:00:00	AAPL	Stock	35.915	35.9375	35.915	35.935	3144.0
2017-04-06 18:30:00	AAPL	Stock	35.915	35.9175	35.9025	35.9025	3204.0
2017-04-06 19:00:00	AAPL	Stock	35.905	35.925	35.9	35.9125	6716.0
2017-04-06 19:30:00	AAPL	Stock	35.9075	35.925	35.9025	35.925	6180.0
2017-04-06 07:30:00	MSFT	Stock	65.63	65.63	65.63	65.63	1360.0
2017-04-06 08:00:00	MSFT	Stock	65.63	65.67	65.59	65.67	3837.0
2017-04-06 08:30:00	MSFT	Stock	65.67	65.67	65.59	65.59	1585.0
2017-04-06 09:00:00	MSFT	Stock	65.59	65.74	65.59	65.66	2983.0
2017-04-06 09:30:00	MSFT	Stock	65.6	65.825	65.48	65.8	2603161.0
2017-04-06 10:00:00	MSFT	Stock	65.8	65.84	65.56	65.79	1266828.0
2017-04-06 10:30:00	MSFT	Stock	65.8	65.98	65.79	65.93	1732184.0
2017-04-06 11:00:00	MSFT	Stock	65.93	66.055	65.92	66.035	1020322.0
2017-04-06 11:30:00	MSFT	Stock	66.034	66.04	65.845	65.92	792202.0
2017-04-06 12:00:00	MSFT	Stock	65.925	65.945	65.75	65.82	634082.0
2017-04-06 12:30:00	MSFT	Stock	65.82	65.86	65.67	65.728	476309.0
2017-04-06 13:00:00	MSFT	Stock	65.73	65.85	65.705	65.81	450438.0
2017-04-06 13:30:00	MSFT	Stock	65.81	65.87	65.7	65.705	452303.0
2017-04-06 14:00:00	MSFT	Stock	65.705	65.74	65.6	65.65	771562.0
2017-04-06 14:30:00	MSFT	Stock	65.64	65.69	65.48	65.53	920634.0
2017-04-06 15:00:00	MSFT	Stock	65.534	65.75	65.53	65.684	881415.0
2017-04-06 15:30:00	MSFT	Stock	65.68	65.77	65.58	65.73	2743289.0
2017-04-06 16:00:00	MSFT	Stock	65.73	65.83	65.69	65.73	2017556.0
2017-04-06 16:30:00	MSFT	Stock	65.835	65.835	65.64	65.64	3772.0

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

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