PREVIEW / stock_30min / 2017-11-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-15.parquet
  size:    1.7 MB
  rows:    85,197
  symbols: 2,934

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-11-15 04:00:00	AAPL	Stock	42.61	42.61	42.5	42.5	44124.0
2017-11-15 04:30:00	AAPL	Stock	42.475	42.49	42.455	42.46	37916.0
2017-11-15 05:00:00	AAPL	Stock	42.5	42.5225	42.475	42.485	29772.0
2017-11-15 05:30:00	AAPL	Stock	42.47	42.515	42.47	42.4875	6952.0
2017-11-15 06:00:00	AAPL	Stock	42.4975	42.55	42.4825	42.55	33340.0
2017-11-15 06:30:00	AAPL	Stock	42.56	42.575	42.5	42.5125	19448.0
2017-11-15 07:00:00	AAPL	Stock	42.51	42.6125	42.505	42.575	99340.0
2017-11-15 07:30:00	AAPL	Stock	42.6075	42.6475	42.5875	42.6475	109568.0
2017-11-15 08:00:00	AAPL	Stock	42.575	42.67	42.5	42.6325	307592.0
2017-11-15 08:30:00	AAPL	Stock	42.6125	42.64	42.535	42.57	282172.0
2017-11-15 09:00:00	AAPL	Stock	42.555	42.555	42.48	42.5075	406756.0
2017-11-15 09:30:00	AAPL	Stock	42.5025	42.5025	42.095	42.25	23427028.0
2017-11-15 10:00:00	AAPL	Stock	42.25	42.4725	42.225	42.3935	9502208.0
2017-11-15 10:30:00	AAPL	Stock	42.3975	42.58	42.39	42.5625	6879904.0
2017-11-15 11:00:00	AAPL	Stock	42.5675	42.575	42.415	42.4475	7925572.0
2017-11-15 11:30:00	AAPL	Stock	42.4475	42.505	42.3612	42.3688	4903068.0
2017-11-15 12:00:00	AAPL	Stock	42.37	42.37	42.28	42.33	4881224.0
2017-11-15 12:30:00	AAPL	Stock	42.3275	42.42	42.3175	42.396	3125520.0
2017-11-15 13:00:00	AAPL	Stock	42.3975	42.4025	42.27	42.28	3452740.0
2017-11-15 13:30:00	AAPL	Stock	42.2825	42.37	42.2388	42.2988	4387904.0
2017-11-15 14:00:00	AAPL	Stock	42.3	42.335	42.25	42.335	3879336.0
2017-11-15 14:30:00	AAPL	Stock	42.3325	42.38	42.31	42.3425	3119260.0
2017-11-15 15:00:00	AAPL	Stock	42.34	42.3825	42.2725	42.279	3996996.0
2017-11-15 15:30:00	AAPL	Stock	42.2775	42.2975	42.1725	42.2725	13236008.0
2017-11-15 16:00:00	AAPL	Stock	42.27	42.3125	42.255	42.285	9614916.0
2017-11-15 16:30:00	AAPL	Stock	42.275	42.3325	42.2625	42.3125	49232.0
2017-11-15 17:00:00	AAPL	Stock	42.305	42.325	42.305	42.305	49184.0
2017-11-15 17:30:00	AAPL	Stock	42.3175	42.3175	42.3	42.3	9724.0
2017-11-15 18:00:00	AAPL	Stock	42.3125	42.3125	42.3	42.3075	22732.0
2017-11-15 18:30:00	AAPL	Stock	42.3025	42.31	42.29	42.3	41712.0
2017-11-15 19:00:00	AAPL	Stock	42.3075	42.32	42.3	42.32	46684.0
2017-11-15 19:30:00	AAPL	Stock	42.32	42.345	42.3175	42.3375	64052.0
2017-11-15 04:00:00	MSFT	Stock	83.55	83.55	83.55	83.55	1483.0
2017-11-15 04:30:00	MSFT	Stock	83.01	83.01	82.61	82.61	2455.0
2017-11-15 05:00:00	MSFT	Stock	82.62	82.92	82.62	82.62	1835.0
2017-11-15 05:30:00	MSFT	Stock	82.73	82.74	82.73	82.73	2000.0
2017-11-15 06:00:00	MSFT	Stock	82.88	82.89	82.88	82.89	434.0
2017-11-15 06:30:00	MSFT	Stock	82.95	83.14	82.93	82.93	4087.0
2017-11-15 07:00:00	MSFT	Stock	83.14	83.2	83.11	83.2	3983.0
2017-11-15 07:30:00	MSFT	Stock	83.22	83.22	83.15	83.15	1420.0
2017-11-15 08:00:00	MSFT	Stock	83.11	83.48	83.05	83.48	39744.0
2017-11-15 08:30:00	MSFT	Stock	83.31	83.59	83.31	83.5	8847.0
2017-11-15 09:00:00	MSFT	Stock	83.41	83.48	83.31	83.44	30441.0
2017-11-15 09:30:00	MSFT	Stock	83.47	83.69	82.99	83.029	2576071.0
2017-11-15 10:00:00	MSFT	Stock	83.025	83.365	82.98	83.265	1240543.0
2017-11-15 10:30:00	MSFT	Stock	83.27	83.31	83.2	83.28	870459.0
2017-11-15 11:00:00	MSFT	Stock	83.28	83.34	83.22	83.251	1224537.0
2017-11-15 11:30:00	MSFT	Stock	83.25	83.3	83.19	83.2	770456.0
2017-11-15 12:00:00	MSFT	Stock	83.21	83.27	83.13	83.25	840622.0
2017-11-15 12:30:00	MSFT	Stock	83.25	83.37	83.22	83.269	434539.0

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

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