PREVIEW / etf_30min / 2018-10-30

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-30.parquet
  size:    492 KB
  rows:    17,149

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-10-30 04:00:00	SPY	ETF	265.22	265.78	264.98	265.7	42065.0
2018-10-30 04:30:00	SPY	ETF	265.61	265.63	265.1	265.18	18834.0
2018-10-30 05:00:00	SPY	ETF	265.02	265.02	263.93	264.19	46365.0
2018-10-30 05:30:00	SPY	ETF	264.17	264.84	264.17	264.73	48019.0
2018-10-30 06:00:00	SPY	ETF	264.85	265.22	264.59	264.96	20794.0
2018-10-30 06:30:00	SPY	ETF	265.04	265.04	264.6	264.65	7675.0
2018-10-30 07:00:00	SPY	ETF	264.74	265.01	264.38	264.98	240074.0
2018-10-30 07:30:00	SPY	ETF	264.98	265.2	264.63	265.05	114060.0
2018-10-30 08:00:00	SPY	ETF	264.83	266.0	264.39	265.2	474981.0
2018-10-30 08:30:00	SPY	ETF	265.17	265.31	264.2	264.26	634329.0
2018-10-30 09:00:00	SPY	ETF	264.24	264.26	262.86	263.68	1515668.0
2018-10-30 09:30:00	SPY	ETF	263.67	267.02	263.12	266.68	16722970.0
2018-10-30 10:00:00	SPY	ETF	266.7	266.92	265.6	265.86	11804222.0
2018-10-30 10:30:00	SPY	ETF	265.875	266.17	264.18	264.59	10917092.0
2018-10-30 11:00:00	SPY	ETF	264.6	265.99	264.09	265.85	9477573.0
2018-10-30 11:30:00	SPY	ETF	265.86	266.88	265.45	265.57	8564356.0
2018-10-30 12:00:00	SPY	ETF	265.58	266.31	265.23	265.83	6303143.0
2018-10-30 12:30:00	SPY	ETF	265.84	265.96	264.66	264.69	5752952.0
2018-10-30 13:00:00	SPY	ETF	264.69	265.1	263.94	264.15	7479727.0
2018-10-30 13:30:00	SPY	ETF	264.13	265.46	263.58	265.32	6339082.0
2018-10-30 14:00:00	SPY	ETF	265.34	265.58	264.12	264.7	7219275.0
2018-10-30 14:30:00	SPY	ETF	264.695	266.61	264.25	266.29	9664091.0
2018-10-30 15:00:00	SPY	ETF	266.28	267.4	265.44	267.105	12835408.0
2018-10-30 15:30:00	SPY	ETF	267.11	268.12	266.76	267.81	24478643.0
2018-10-30 16:00:00	SPY	ETF	267.82	268.41	267.65	268.06	11521368.0
2018-10-30 16:30:00	SPY	ETF	268.05	268.51	263.6858	268.39	1375659.0
2018-10-30 17:00:00	SPY	ETF	268.37	268.44	267.66	267.72	582620.0
2018-10-30 17:30:00	SPY	ETF	267.71	268.46	267.58	268.41	230788.0
2018-10-30 18:00:00	SPY	ETF	268.46	268.6	268.11	268.32	194651.0
2018-10-30 18:30:00	SPY	ETF	268.29	268.29	268.07	268.17	91959.0
2018-10-30 19:00:00	SPY	ETF	268.08	268.34	268.05	268.2	60522.0
2018-10-30 19:30:00	SPY	ETF	268.23	268.39	268.14	268.21	39157.0
2018-10-30 04:00:00	QQQ	ETF	164.88	165.14	164.63	165.08	19695.0
2018-10-30 04:30:00	QQQ	ETF	165.07	165.07	164.65	164.73	12634.0
2018-10-30 05:00:00	QQQ	ETF	164.75	164.75	163.48	163.57	42525.0
2018-10-30 05:30:00	QQQ	ETF	163.46	164.38	163.46	164.38	31430.0
2018-10-30 06:00:00	QQQ	ETF	164.25	164.56	164.04	164.42	28247.0
2018-10-30 06:30:00	QQQ	ETF	164.45	164.5	164.04	164.27	25936.0
2018-10-30 07:00:00	QQQ	ETF	164.22	164.43	163.83	164.38	83476.0
2018-10-30 07:30:00	QQQ	ETF	164.44	164.68	164.14	164.5	90975.0
2018-10-30 08:00:00	QQQ	ETF	164.18	165.28	163.82	164.5	321439.0
2018-10-30 08:30:00	QQQ	ETF	164.49	164.6	163.49	163.55	506859.0
2018-10-30 09:00:00	QQQ	ETF	163.55	163.55	162.04	162.83	1764590.0
2018-10-30 09:30:00	QQQ	ETF	162.83	165.52	162.015	165.13	14989249.0
2018-10-30 10:00:00	QQQ	ETF	165.14	165.279	163.99	164.57	8983702.0
2018-10-30 10:30:00	QQQ	ETF	164.57	165.055	162.87	163.46	7505253.0
2018-10-30 11:00:00	QQQ	ETF	163.47	164.84	163.11	164.79	5727633.0
2018-10-30 11:30:00	QQQ	ETF	164.79	165.7	164.57	164.66	5395649.0
2018-10-30 12:00:00	QQQ	ETF	164.66	165.21	164.16	164.76	3871335.0
2018-10-30 12:30:00	QQQ	ETF	164.74	165.08	163.79	163.84	2960210.0

> showing 50 of 17,149 rows — these rows as CSV

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