PREVIEW / stock_30min / 2017-04-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-25.parquet
  size:    1.6 MB
  rows:    83,166
  symbols: 3,069

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-25 04:00:00	AAPL	Stock	35.985	35.985	35.985	35.985	4000.0
2017-04-25 05:00:00	AAPL	Stock	35.975	35.975	35.9625	35.9625	6416.0
2017-04-25 07:00:00	AAPL	Stock	35.975	35.975	35.965	35.9675	12400.0
2017-04-25 07:30:00	AAPL	Stock	35.985	35.99	35.975	35.99	20572.0
2017-04-25 08:00:00	AAPL	Stock	35.99	36.025	35.98	36.0225	70324.0
2017-04-25 08:30:00	AAPL	Stock	36.025	36.05	36.015	36.015	80992.0
2017-04-25 09:00:00	AAPL	Stock	36.015	36.05	35.925	36.0075	258936.0
2017-04-25 09:30:00	AAPL	Stock	35.9925	36.115	35.9675	36.04	10785960.0
2017-04-25 10:00:00	AAPL	Stock	36.04	36.0975	36.025	36.0625	5699228.0
2017-04-25 10:30:00	AAPL	Stock	36.0625	36.115	36.0575	36.1	4085988.0
2017-04-25 11:00:00	AAPL	Stock	36.0975	36.175	36.09	36.119	4621384.0
2017-04-25 11:30:00	AAPL	Stock	36.119	36.175	36.1075	36.1425	3244544.0
2017-04-25 12:00:00	AAPL	Stock	36.145	36.1725	36.14	36.1538	2278628.0
2017-04-25 12:30:00	AAPL	Stock	36.1525	36.1538	36.11	36.111	2419292.0
2017-04-25 13:00:00	AAPL	Stock	36.1115	36.1675	36.1075	36.156	2736368.0
2017-04-25 13:30:00	AAPL	Stock	36.1575	36.1875	36.145	36.1788	2903088.0
2017-04-25 14:00:00	AAPL	Stock	36.1788	36.205	36.17	36.1812	3311772.0
2017-04-25 14:30:00	AAPL	Stock	36.1825	36.2	36.155	36.1592	3702672.0
2017-04-25 15:00:00	AAPL	Stock	36.16	36.225	36.1575	36.1987	4547648.0
2017-04-25 15:30:00	AAPL	Stock	36.1987	36.2075	36.1275	36.1325	8601212.0
2017-04-25 16:00:00	AAPL	Stock	36.135	36.1375	36.115	36.12	7836416.0
2017-04-25 16:30:00	AAPL	Stock	36.1225	36.1225	36.1125	36.1125	14380.0
2017-04-25 17:00:00	AAPL	Stock	36.1125	36.12	36.1125	36.115	14032.0
2017-04-25 17:30:00	AAPL	Stock	36.1125	36.115	36.065	36.075	106864.0
2017-04-25 18:00:00	AAPL	Stock	36.07	36.09	36.07	36.09	4824.0
2017-04-25 18:30:00	AAPL	Stock	36.1	36.1	36.09	36.1	4456.0
2017-04-25 19:00:00	AAPL	Stock	36.1	36.1175	36.1	36.1	14100.0
2017-04-25 19:30:00	AAPL	Stock	36.12	36.125	36.1	36.12	51716.0
2017-04-25 04:00:00	MSFT	Stock	67.39	67.39	67.39	67.39	150.0
2017-04-25 07:00:00	MSFT	Stock	67.7	67.7	67.7	67.7	431.0
2017-04-25 07:30:00	MSFT	Stock	67.6	67.73	67.6	67.73	1047.0
2017-04-25 08:00:00	MSFT	Stock	67.7	67.95	67.6	67.82	17026.0
2017-04-25 08:30:00	MSFT	Stock	67.8	67.8	67.7	67.8	3012.0
2017-04-25 09:00:00	MSFT	Stock	67.85	67.92	67.8	67.86	15737.0
2017-04-25 09:30:00	MSFT	Stock	67.9	67.98	67.6	67.81	3040941.0
2017-04-25 10:00:00	MSFT	Stock	67.8	68.0	67.73	67.93	1575371.0
2017-04-25 10:30:00	MSFT	Stock	67.93	67.96	67.87	67.9	1217028.0
2017-04-25 11:00:00	MSFT	Stock	67.9	68.0	67.84	67.96	2175644.0
2017-04-25 11:30:00	MSFT	Stock	67.96	67.99	67.91	67.93	1200966.0
2017-04-25 12:00:00	MSFT	Stock	67.93	67.98	67.88	67.945	1046602.0
2017-04-25 12:30:00	MSFT	Stock	67.94	67.97	67.83	67.83	913270.0
2017-04-25 13:00:00	MSFT	Stock	67.835	67.93	67.82	67.84	1106233.0
2017-04-25 13:30:00	MSFT	Stock	67.85	67.88	67.76	67.825	1292314.0
2017-04-25 14:00:00	MSFT	Stock	67.82	67.85	67.8	67.826	1234994.0
2017-04-25 14:30:00	MSFT	Stock	67.825	67.865	67.79	67.835	1103147.0
2017-04-25 15:00:00	MSFT	Stock	67.834	67.945	67.834	67.875	2146389.0
2017-04-25 15:30:00	MSFT	Stock	67.875	68.04	67.84	67.92	3815798.0
2017-04-25 16:00:00	MSFT	Stock	67.95	68.05	67.887	68.0	6722031.0
2017-04-25 16:30:00	MSFT	Stock	67.96	68.0	67.96	68.0	2945.0
2017-04-25 17:00:00	MSFT	Stock	67.94	67.94	67.92	67.92	1300.0

> showing 50 of 83,166 rows — these rows as CSV

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