PREVIEW / stock_30min / 2018-04-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-09.parquet
  size:    1.6 MB
  rows:    82,242
  symbols: 2,856

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
2018-04-09 04:00:00	AAPL	Stock	42.535	42.6225	42.535	42.6225	800.0
2018-04-09 04:30:00	AAPL	Stock	42.6	42.6125	42.6	42.6125	1500.0
2018-04-09 05:00:00	AAPL	Stock	42.6075	42.61	42.6075	42.6075	2208.0
2018-04-09 05:30:00	AAPL	Stock	42.5625	42.6075	42.5625	42.6075	804.0
2018-04-09 06:00:00	AAPL	Stock	42.6025	42.6875	42.6025	42.6225	6972.0
2018-04-09 06:30:00	AAPL	Stock	42.6725	42.6725	42.5625	42.5625	49184.0
2018-04-09 07:00:00	AAPL	Stock	42.575	42.6125	42.515	42.5625	150196.0
2018-04-09 07:30:00	AAPL	Stock	42.55	42.5625	42.47	42.5225	52596.0
2018-04-09 08:00:00	AAPL	Stock	42.54	42.6125	42.4	42.515	202804.0
2018-04-09 08:30:00	AAPL	Stock	42.525	42.56	42.4925	42.4925	187824.0
2018-04-09 09:00:00	AAPL	Stock	42.495	42.5375	42.4375	42.4725	153548.0
2018-04-09 09:30:00	AAPL	Stock	42.4525	42.9	42.4525	42.8375	14712400.0
2018-04-09 10:00:00	AAPL	Stock	42.84	42.92	42.705	42.8975	7976052.0
2018-04-09 10:30:00	AAPL	Stock	42.9	42.9875	42.865	42.9375	6848628.0
2018-04-09 11:00:00	AAPL	Stock	42.94	43.03	42.8425	43.0122	5987128.0
2018-04-09 11:30:00	AAPL	Stock	43.0075	43.12	42.9925	43.1112	6400620.0
2018-04-09 12:00:00	AAPL	Stock	43.1125	43.245	43.07	43.1275	6067660.0
2018-04-09 12:30:00	AAPL	Stock	43.1225	43.2038	42.985	43.2	4861916.0
2018-04-09 13:00:00	AAPL	Stock	43.2	43.2725	43.14	43.205	4375152.0
2018-04-09 13:30:00	AAPL	Stock	43.205	43.26	43.155	43.245	4098808.0
2018-04-09 14:00:00	AAPL	Stock	43.245	43.2575	42.9925	43.08	4854788.0
2018-04-09 14:30:00	AAPL	Stock	43.08	43.1175	42.8875	43.1	5104980.0
2018-04-09 15:00:00	AAPL	Stock	43.1025	43.112	42.76	42.8762	6093368.0
2018-04-09 15:30:00	AAPL	Stock	42.875	42.89	42.465	42.515	12032064.0
2018-04-09 16:00:00	AAPL	Stock	42.5125	43.0775	42.4375	42.5275	12988192.0
2018-04-09 16:30:00	AAPL	Stock	42.55	42.635	42.4875	42.5125	74428.0
2018-04-09 17:00:00	AAPL	Stock	42.5275	42.555	42.5	42.55	53048.0
2018-04-09 17:30:00	AAPL	Stock	42.5225	42.525	42.5025	42.5125	21312.0
2018-04-09 18:00:00	AAPL	Stock	42.515	42.535	42.5	42.5125	27180.0
2018-04-09 18:30:00	AAPL	Stock	42.5125	42.575	42.5025	42.5025	32552.0
2018-04-09 19:00:00	AAPL	Stock	42.5	42.55	42.5	42.55	16480.0
2018-04-09 19:30:00	AAPL	Stock	42.515	42.55	42.5	42.535	43936.0
2018-04-09 04:00:00	MSFT	Stock	91.03	91.2	91.03	91.2	900.0
2018-04-09 05:00:00	MSFT	Stock	91.25	91.25	91.25	91.25	400.0
2018-04-09 05:30:00	MSFT	Stock	91.34	91.41	91.26	91.26	3045.0
2018-04-09 06:00:00	MSFT	Stock	91.2	91.2	91.2	91.2	100.0
2018-04-09 06:30:00	MSFT	Stock	91.21	91.4	91.11	91.11	4133.0
2018-04-09 07:00:00	MSFT	Stock	91.11	91.25	91.0	91.15	12745.0
2018-04-09 07:30:00	MSFT	Stock	91.0	91.1	90.94	91.0	2100.0
2018-04-09 08:00:00	MSFT	Stock	91.2	91.25	90.9	91.0	8578.0
2018-04-09 08:30:00	MSFT	Stock	91.0	91.14	90.9	91.05	13190.0
2018-04-09 09:00:00	MSFT	Stock	91.02	91.14	91.0	91.04	9681.0
2018-04-09 09:30:00	MSFT	Stock	91.03	92.08	91.03	91.79	2943430.0
2018-04-09 10:00:00	MSFT	Stock	91.8	92.07	91.57	92.035	1687308.0
2018-04-09 10:30:00	MSFT	Stock	92.03	92.375	92.02	92.15	1627356.0
2018-04-09 11:00:00	MSFT	Stock	92.15	92.37	91.93	92.26	1063587.0
2018-04-09 11:30:00	MSFT	Stock	92.25	92.84	92.25	92.82	1505542.0
2018-04-09 12:00:00	MSFT	Stock	92.82	93.17	92.71	92.95	1571359.0
2018-04-09 12:30:00	MSFT	Stock	92.945	93.02	92.67	92.84	1076184.0
2018-04-09 13:00:00	MSFT	Stock	92.83	93.005	92.59	92.74	1002285.0

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

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