PREVIEW / etf_30min / 2017-01-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-26.parquet
  size:    438 KB
  rows:    14,927

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-26 04:00:00	SPY	ETF	229.71	229.77	229.69	229.69	6913.0
2017-01-26 04:30:00	SPY	ETF	229.73	229.78	229.73	229.78	1286.0
2017-01-26 05:00:00	SPY	ETF	229.74	229.74	229.67	229.67	4800.0
2017-01-26 05:30:00	SPY	ETF	229.66	229.69	229.64	229.69	1000.0
2017-01-26 06:00:00	SPY	ETF	229.68	229.68	229.55	229.55	1751.0
2017-01-26 06:30:00	SPY	ETF	229.58	229.58	229.47	229.55	2906.0
2017-01-26 07:00:00	SPY	ETF	229.6	229.6	229.52	229.57	24410.0
2017-01-26 07:30:00	SPY	ETF	229.57	229.59	229.43	229.44	102519.0
2017-01-26 08:00:00	SPY	ETF	229.52	229.58	229.32	229.37	254144.0
2017-01-26 08:30:00	SPY	ETF	229.39	229.57	229.37	229.52	203199.0
2017-01-26 09:00:00	SPY	ETF	229.5	229.57	229.34	229.39	326081.0
2017-01-26 09:30:00	SPY	ETF	229.4	229.66	229.24	229.56	5604868.0
2017-01-26 10:00:00	SPY	ETF	229.555	229.71	229.33	229.375	5541812.0
2017-01-26 10:30:00	SPY	ETF	229.37	229.7	229.3	229.39	2439039.0
2017-01-26 11:00:00	SPY	ETF	229.39	229.54	229.26	229.4	2868216.0
2017-01-26 11:30:00	SPY	ETF	229.4	229.53	229.26	229.32	3070964.0
2017-01-26 12:00:00	SPY	ETF	229.33	229.4	229.21	229.28	1631574.0
2017-01-26 12:30:00	SPY	ETF	229.285	229.32	229.14	229.29	2527841.0
2017-01-26 13:00:00	SPY	ETF	229.29	229.34	229.01	229.17	4310388.0
2017-01-26 13:30:00	SPY	ETF	229.17	229.32	229.11	229.32	2550050.0
2017-01-26 14:00:00	SPY	ETF	229.315	229.49	229.22	229.48	3595074.0
2017-01-26 14:30:00	SPY	ETF	229.48	229.52	229.36	229.375	2998513.0
2017-01-26 15:00:00	SPY	ETF	229.37	229.39	229.19	229.31	3751709.0
2017-01-26 15:30:00	SPY	ETF	229.31	229.43	229.085	229.3	9833613.0
2017-01-26 16:00:00	SPY	ETF	229.31	229.53	229.2669	229.49	5971738.0
2017-01-26 16:30:00	SPY	ETF	229.5	229.5	229.2666	229.48	507366.0
2017-01-26 17:00:00	SPY	ETF	229.47	229.56	229.2666	229.52	123622.0
2017-01-26 17:30:00	SPY	ETF	229.267	229.56	229.267	229.43	212638.0
2017-01-26 18:00:00	SPY	ETF	229.43	229.48	229.39	229.39	53612.0
2017-01-26 18:30:00	SPY	ETF	229.38	229.38	229.31	229.33	40887.0
2017-01-26 19:00:00	SPY	ETF	229.33	229.33	229.23	229.23	19287.0
2017-01-26 19:30:00	SPY	ETF	229.26	229.26	229.22	229.26	10820.0
2017-01-26 04:00:00	QQQ	ETF	125.71	125.82	125.69	125.75	2048.0
2017-01-26 04:30:00	QQQ	ETF	125.78	125.78	125.74	125.74	1254.0
2017-01-26 06:00:00	QQQ	ETF	125.7	125.7	125.63	125.64	24000.0
2017-01-26 06:30:00	QQQ	ETF	125.64	125.65	125.62	125.63	30497.0
2017-01-26 07:00:00	QQQ	ETF	125.65	125.71	125.65	125.66	34095.0
2017-01-26 07:30:00	QQQ	ETF	125.67	125.67	125.61	125.61	22446.0
2017-01-26 08:00:00	QQQ	ETF	125.67	125.67	125.52	125.58	88172.0
2017-01-26 08:30:00	QQQ	ETF	125.58	125.63	125.55	125.59	47327.0
2017-01-26 09:00:00	QQQ	ETF	125.59	125.66	125.57	125.62	109902.0
2017-01-26 09:30:00	QQQ	ETF	125.59	125.82	125.48	125.64	2106312.0
2017-01-26 10:00:00	QQQ	ETF	125.64	125.69	125.43	125.4308	1680688.0
2017-01-26 10:30:00	QQQ	ETF	125.44	125.575	125.4	125.4381	1230076.0
2017-01-26 11:00:00	QQQ	ETF	125.44	125.565	125.3438	125.55	858833.0
2017-01-26 11:30:00	QQQ	ETF	125.555	125.63	125.506	125.509	979699.0
2017-01-26 12:00:00	QQQ	ETF	125.51	125.59	125.45	125.54	610474.0
2017-01-26 12:30:00	QQQ	ETF	125.545	125.635	125.51	125.58	623054.0
2017-01-26 13:00:00	QQQ	ETF	125.58	125.65	125.44	125.49	473679.0
2017-01-26 13:30:00	QQQ	ETF	125.495	125.56	125.46	125.56	436065.0

> showing 50 of 14,927 rows — these rows as CSV

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