PREVIEW / stock_30min / 2017-01-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-18.parquet
  size:    1.6 MB
  rows:    81,076
  symbols: 3,127

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-01-18 04:00:00	AAPL	Stock	30.0	30.0	30.0	30.0	2632.0
2017-01-18 05:30:00	AAPL	Stock	30.0	30.0325	30.0	30.0325	3476.0
2017-01-18 06:00:00	AAPL	Stock	29.9775	30.05	29.975	30.05	7716.0
2017-01-18 06:30:00	AAPL	Stock	30.0475	30.0475	30.0025	30.0025	14800.0
2017-01-18 07:00:00	AAPL	Stock	30.0025	30.025	29.975	29.975	28848.0
2017-01-18 07:30:00	AAPL	Stock	29.9975	30.015	29.9975	30.015	4984.0
2017-01-18 08:00:00	AAPL	Stock	30.0175	30.03	29.9975	30.025	53916.0
2017-01-18 08:30:00	AAPL	Stock	30.0375	30.04	30.0125	30.0275	105316.0
2017-01-18 09:00:00	AAPL	Stock	30.0325	30.0325	30.0	30.005	178416.0
2017-01-18 09:30:00	AAPL	Stock	30.0	30.125	29.9925	30.06	16382224.0
2017-01-18 10:00:00	AAPL	Stock	30.0625	30.065	29.9275	29.9775	7431148.0
2017-01-18 10:30:00	AAPL	Stock	29.975	30.035	29.97	29.9975	5107036.0
2017-01-18 11:00:00	AAPL	Stock	29.9975	30.0225	29.975	29.9975	10856532.0
2017-01-18 11:30:00	AAPL	Stock	30.0	30.0075	29.9525	29.965	3858108.0
2017-01-18 12:00:00	AAPL	Stock	29.965	30.005	29.9575	29.9825	3090100.0
2017-01-18 12:30:00	AAPL	Stock	29.9832	30.0125	29.9725	29.9725	2377320.0
2017-01-18 13:00:00	AAPL	Stock	29.9725	30.0	29.965	29.9912	2931788.0
2017-01-18 13:30:00	AAPL	Stock	29.9925	30.0172	29.99	29.9962	2588316.0
2017-01-18 14:00:00	AAPL	Stock	29.9962	30.02	29.995	30.0125	3404400.0
2017-01-18 14:30:00	AAPL	Stock	30.0125	30.0225	29.99	30.02	3230240.0
2017-01-18 15:00:00	AAPL	Stock	30.0185	30.0625	29.9975	30.021	4997376.0
2017-01-18 15:30:00	AAPL	Stock	30.0225	30.0225	29.9875	29.9925	8004068.0
2017-01-18 16:00:00	AAPL	Stock	29.9975	30.0175	29.99	30.0	9585300.0
2017-01-18 16:30:00	AAPL	Stock	30.0075	30.0175	29.9825	29.9875	32572.0
2017-01-18 17:00:00	AAPL	Stock	29.9825	29.9975	29.9825	29.9925	135812.0
2017-01-18 17:30:00	AAPL	Stock	29.99	29.995	29.99	29.99	5040.0
2017-01-18 18:00:00	AAPL	Stock	29.995	29.995	29.9875	29.9875	13452.0
2017-01-18 18:30:00	AAPL	Stock	29.9875	29.99	29.98	29.99	8020.0
2017-01-18 19:30:00	AAPL	Stock	29.9875	29.995	29.985	29.995	31492.0
2017-01-18 05:00:00	MSFT	Stock	62.73	62.83	62.73	62.83	348.0
2017-01-18 05:30:00	MSFT	Stock	62.73	62.73	62.7	62.7	459.0
2017-01-18 06:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	159.0
2017-01-18 07:30:00	MSFT	Stock	62.6	62.6	62.56	62.59	1200.0
2017-01-18 08:00:00	MSFT	Stock	62.5	62.5	62.5	62.5	100.0
2017-01-18 08:30:00	MSFT	Stock	62.65	62.65	62.65	62.65	100.0
2017-01-18 09:00:00	MSFT	Stock	62.66	62.8	62.52	62.55	9238.0
2017-01-18 09:30:00	MSFT	Stock	62.67	62.7	62.12	62.44	2567792.0
2017-01-18 10:00:00	MSFT	Stock	62.435	62.53	62.33	62.365	1366412.0
2017-01-18 10:30:00	MSFT	Stock	62.367	62.44	62.2	62.37	1381089.0
2017-01-18 11:00:00	MSFT	Stock	62.36	62.386	62.27	62.345	871888.0
2017-01-18 11:30:00	MSFT	Stock	62.34	62.375	62.21	62.24	894295.0
2017-01-18 12:00:00	MSFT	Stock	62.23	62.39	62.23	62.38	746768.0
2017-01-18 12:30:00	MSFT	Stock	62.37	62.46	62.35	62.385	513089.0
2017-01-18 13:00:00	MSFT	Stock	62.38	62.44	62.34	62.36	363564.0
2017-01-18 13:30:00	MSFT	Stock	62.37	62.44	62.365	62.38	388570.0
2017-01-18 14:00:00	MSFT	Stock	62.385	62.45	62.36	62.395	577352.0
2017-01-18 14:30:00	MSFT	Stock	62.395	62.43	62.31	62.425	592526.0
2017-01-18 15:00:00	MSFT	Stock	62.42	62.45	62.355	62.38	790971.0
2017-01-18 15:30:00	MSFT	Stock	62.387	62.53	62.345	62.49	2377629.0
2017-01-18 16:00:00	MSFT	Stock	62.5	62.52	62.5	62.52	3943520.0

> showing 50 of 81,076 rows — these rows as CSV

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