PREVIEW / stock_30min / 2017-12-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-18.parquet
  size:    1.7 MB
  rows:    85,948
  symbols: 2,951

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-12-18 04:00:00	AAPL	Stock	43.56	43.75	43.56	43.75	21132.0
2017-12-18 04:30:00	AAPL	Stock	43.76	43.7675	43.7075	43.7075	7284.0
2017-12-18 05:30:00	AAPL	Stock	43.7275	43.7675	43.7275	43.7625	4844.0
2017-12-18 06:00:00	AAPL	Stock	43.78	43.975	43.78	43.85	76792.0
2017-12-18 06:30:00	AAPL	Stock	43.85	43.8625	43.83	43.83	5300.0
2017-12-18 07:00:00	AAPL	Stock	43.8175	43.84	43.725	43.75	108592.0
2017-12-18 07:30:00	AAPL	Stock	43.75	43.7825	43.725	43.7625	71556.0
2017-12-18 08:00:00	AAPL	Stock	43.8875	43.8875	43.7325	43.775	242608.0
2017-12-18 08:30:00	AAPL	Stock	43.7575	43.7575	43.7025	43.7275	107304.0
2017-12-18 09:00:00	AAPL	Stock	43.705	43.745	43.7025	43.715	179048.0
2017-12-18 09:30:00	AAPL	Stock	43.73	44.07	43.715	44.0525	19766684.0
2017-12-18 10:00:00	AAPL	Stock	44.0525	44.15	44.034	44.0865	9869160.0
2017-12-18 10:30:00	AAPL	Stock	44.0888	44.11	43.9888	44.0865	7091888.0
2017-12-18 11:00:00	AAPL	Stock	44.085	44.1725	44.0525	44.1562	5827356.0
2017-12-18 11:30:00	AAPL	Stock	44.1575	44.1575	44.0875	44.13	3335676.0
2017-12-18 12:00:00	AAPL	Stock	44.1325	44.1575	44.0675	44.075	2708368.0
2017-12-18 12:30:00	AAPL	Stock	44.075	44.14	44.0725	44.1175	3385152.0
2017-12-18 13:00:00	AAPL	Stock	44.1165	44.2	44.0925	44.2	3983580.0
2017-12-18 13:30:00	AAPL	Stock	44.2	44.2525	44.19	44.2522	4914912.0
2017-12-18 14:00:00	AAPL	Stock	44.2525	44.2925	44.2075	44.2125	4121960.0
2017-12-18 14:30:00	AAPL	Stock	44.211	44.2825	44.165	44.275	3672356.0
2017-12-18 15:00:00	AAPL	Stock	44.2725	44.2725	44.1775	44.1825	3884628.0
2017-12-18 15:30:00	AAPL	Stock	44.18	44.3	44.1075	44.1075	14060112.0
2017-12-18 16:00:00	AAPL	Stock	44.1075	44.2425	44.105	44.105	19513016.0
2017-12-18 16:30:00	AAPL	Stock	44.13	44.1425	44.1125	44.13	44608.0
2017-12-18 17:00:00	AAPL	Stock	44.1175	44.12	44.105	44.115	53244.0
2017-12-18 17:30:00	AAPL	Stock	44.1075	44.115	44.105	44.1075	18696.0
2017-12-18 18:00:00	AAPL	Stock	44.12	44.125	44.12	44.12	21288.0
2017-12-18 18:30:00	AAPL	Stock	44.1375	44.15	44.125	44.1475	6220.0
2017-12-18 19:00:00	AAPL	Stock	44.1475	44.165	44.12	44.1375	39040.0
2017-12-18 19:30:00	AAPL	Stock	44.15	44.15	44.1125	44.1475	44872.0
2017-12-18 04:00:00	MSFT	Stock	87.3	87.3	87.3	87.3	4911.0
2017-12-18 04:30:00	MSFT	Stock	87.51	87.51	87.3	87.51	2342.0
2017-12-18 05:00:00	MSFT	Stock	87.88	87.88	87.32	87.32	539.0
2017-12-18 06:00:00	MSFT	Stock	87.65	87.65	87.64	87.64	1526.0
2017-12-18 06:30:00	MSFT	Stock	87.65	87.65	87.64	87.64	3018.0
2017-12-18 07:00:00	MSFT	Stock	87.42	87.64	87.42	87.63	3469.0
2017-12-18 07:30:00	MSFT	Stock	87.6	87.63	87.54	87.55	5908.0
2017-12-18 08:00:00	MSFT	Stock	87.37	87.64	87.34	87.61	30959.0
2017-12-18 08:30:00	MSFT	Stock	87.41	87.47	87.21	87.34	14380.0
2017-12-18 09:00:00	MSFT	Stock	87.34	87.45	87.25	87.37	17127.0
2017-12-18 09:30:00	MSFT	Stock	87.12	87.5	86.86	87.02	2475169.0
2017-12-18 10:00:00	MSFT	Stock	87.035	87.1	86.69	86.88	1335499.0
2017-12-18 10:30:00	MSFT	Stock	86.88	86.9	86.585	86.59	1178085.0
2017-12-18 11:00:00	MSFT	Stock	86.585	86.62	86.36	86.52	1126257.0
2017-12-18 11:30:00	MSFT	Stock	86.52	86.86	86.48	86.76	972324.0
2017-12-18 12:00:00	MSFT	Stock	86.75	86.96	86.72	86.76	760706.0
2017-12-18 12:30:00	MSFT	Stock	86.75	86.83	86.71	86.825	693211.0
2017-12-18 13:00:00	MSFT	Stock	86.83	86.88	86.78	86.855	656823.0
2017-12-18 13:30:00	MSFT	Stock	86.85	86.88	86.67	86.69	772626.0

> showing 50 of 85,948 rows — these rows as CSV

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