PREVIEW / etf_30min / 2017-12-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-06.parquet
  size:    450 KB
  rows:    15,655

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-06 04:00:00	SPY	ETF	262.86	262.87	262.74	262.79	7010.0
2017-12-06 04:30:00	SPY	ETF	262.78	262.78	262.58	262.58	15000.0
2017-12-06 05:00:00	SPY	ETF	262.62	262.62	262.56	262.62	4045.0
2017-12-06 05:30:00	SPY	ETF	262.64	262.78	262.63	262.78	740.0
2017-12-06 06:00:00	SPY	ETF	262.69	262.87	262.6	262.82	10997.0
2017-12-06 06:30:00	SPY	ETF	262.8	262.85	262.7	262.72	15822.0
2017-12-06 07:00:00	SPY	ETF	262.85	262.91	262.75	262.75	121218.0
2017-12-06 07:30:00	SPY	ETF	262.78	262.94	262.78	262.94	83885.0
2017-12-06 08:00:00	SPY	ETF	262.8	262.94	262.7	262.74	203764.0
2017-12-06 08:30:00	SPY	ETF	262.72	263.06	262.62	263.03	735336.0
2017-12-06 09:00:00	SPY	ETF	263.03	263.07	262.79	262.84	265186.0
2017-12-06 09:30:00	SPY	ETF	262.87	263.41	262.83	263.23	7388500.0
2017-12-06 10:00:00	SPY	ETF	263.23	263.52	262.89	263.05	3613344.0
2017-12-06 10:30:00	SPY	ETF	263.06	263.58	262.71	263.565	5148143.0
2017-12-06 11:00:00	SPY	ETF	263.57	263.66	263.28	263.32	4862040.0
2017-12-06 11:30:00	SPY	ETF	263.32	263.42	263.13	263.245	1928457.0
2017-12-06 12:00:00	SPY	ETF	263.24	263.26	262.88	262.935	3270100.0
2017-12-06 12:30:00	SPY	ETF	262.93	263.28	262.9	263.18	3596220.0
2017-12-06 13:00:00	SPY	ETF	263.2	263.28	263.05	263.19	1812408.0
2017-12-06 13:30:00	SPY	ETF	263.18	263.515	263.15	263.479	2241565.0
2017-12-06 14:00:00	SPY	ETF	263.47	263.63	263.37	263.449	5254194.0
2017-12-06 14:30:00	SPY	ETF	263.445	263.73	263.37	263.515	3643206.0
2017-12-06 15:00:00	SPY	ETF	263.51	263.63	263.39	263.44	3457312.0
2017-12-06 15:30:00	SPY	ETF	263.44	263.47	263.065	263.21	9249381.0
2017-12-06 16:00:00	SPY	ETF	263.21	263.3	262.93	263.22	9118213.0
2017-12-06 16:30:00	SPY	ETF	263.22	263.47	263.15	263.42	1309652.0
2017-12-06 17:00:00	SPY	ETF	263.4	263.53	263.37	263.44	106841.0
2017-12-06 17:30:00	SPY	ETF	263.44	263.44	263.35	263.36	52787.0
2017-12-06 18:00:00	SPY	ETF	263.36	263.49	263.1523	263.49	239575.0
2017-12-06 18:30:00	SPY	ETF	263.48	263.56	263.45	263.48	42511.0
2017-12-06 19:00:00	SPY	ETF	263.48	263.66	263.48	263.65	26038.0
2017-12-06 19:30:00	SPY	ETF	263.65	263.88	263.65	263.82	33388.0
2017-12-06 04:00:00	QQQ	ETF	152.51	152.51	152.29	152.41	2350.0
2017-12-06 04:30:00	QQQ	ETF	152.31	152.31	152.19	152.19	7800.0
2017-12-06 05:00:00	QQQ	ETF	152.27	152.32	152.03	152.03	7007.0
2017-12-06 05:30:00	QQQ	ETF	152.11	152.15	152.02	152.15	21200.0
2017-12-06 06:00:00	QQQ	ETF	152.05	152.3	152.05	152.28	22700.0
2017-12-06 06:30:00	QQQ	ETF	152.23	152.26	152.18	152.18	3400.0
2017-12-06 07:00:00	QQQ	ETF	152.26	152.33	152.13	152.13	13277.0
2017-12-06 07:30:00	QQQ	ETF	152.15	152.49	152.15	152.47	74550.0
2017-12-06 08:00:00	QQQ	ETF	152.26	152.52	152.18	152.42	111345.0
2017-12-06 08:30:00	QQQ	ETF	152.39	152.56	152.39	152.54	156381.0
2017-12-06 09:00:00	QQQ	ETF	152.54	152.54	152.17	152.225	456726.0
2017-12-06 09:30:00	QQQ	ETF	152.26	153.19	152.06	153.0	4849400.0
2017-12-06 10:00:00	QQQ	ETF	153.0	153.38	152.84	153.11	2626868.0
2017-12-06 10:30:00	QQQ	ETF	153.12	153.3	152.63	153.29	2435298.0
2017-12-06 11:00:00	QQQ	ETF	153.28	153.52	153.07	153.12	1945815.0
2017-12-06 11:30:00	QQQ	ETF	153.12	153.29	153.0	153.2175	775645.0
2017-12-06 12:00:00	QQQ	ETF	153.21	153.32	152.87	152.87	1034955.0
2017-12-06 12:30:00	QQQ	ETF	152.87	153.19	152.85	153.07	567331.0

> showing 50 of 15,655 rows — these rows as CSV

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