PREVIEW / etf_30min / 2018-11-20

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-20.parquet
  size:    520 KB
  rows:    18,100

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-11-20 04:00:00	SPY	ETF	267.93	267.93	267.27	267.72	21812.0
2018-11-20 04:30:00	SPY	ETF	267.82	268.05	267.6	267.6	7945.0
2018-11-20 05:00:00	SPY	ETF	267.61	267.99	267.35	267.92	41181.0
2018-11-20 05:30:00	SPY	ETF	267.92	267.96	267.51	267.66	90494.0
2018-11-20 06:00:00	SPY	ETF	267.63	267.82	267.45	267.47	57802.0
2018-11-20 06:30:00	SPY	ETF	267.47	268.31	267.27	268.1	396258.0
2018-11-20 07:00:00	SPY	ETF	268.1	268.1	267.15	267.24	538744.0
2018-11-20 07:30:00	SPY	ETF	267.2	267.36	266.21	266.31	360036.0
2018-11-20 08:00:00	SPY	ETF	267.46	268.95	266.2	266.41	712332.0
2018-11-20 08:30:00	SPY	ETF	266.44	266.54	265.46	265.54	1037187.0
2018-11-20 09:00:00	SPY	ETF	265.53	269.1	265.05	265.37	1675817.0
2018-11-20 09:30:00	SPY	ETF	265.36	266.09	264.04	264.62	18891036.0
2018-11-20 10:00:00	SPY	ETF	264.6102	265.16	263.32	265.025	17005593.0
2018-11-20 10:30:00	SPY	ETF	265.025	266.8	264.7	266.61	11175651.0
2018-11-20 11:00:00	SPY	ETF	266.63	266.79	265.09	265.16	6707665.0
2018-11-20 11:30:00	SPY	ETF	265.1546	266.67	264.83	266.28	5830591.0
2018-11-20 12:00:00	SPY	ETF	266.27	267.0	265.44	266.19	5412600.0
2018-11-20 12:30:00	SPY	ETF	266.1801	266.48	265.125	265.2011	3925151.0
2018-11-20 13:00:00	SPY	ETF	265.2	265.51	264.28	264.62	4459819.0
2018-11-20 13:30:00	SPY	ETF	264.61	265.33	264.36	264.37	5288404.0
2018-11-20 14:00:00	SPY	ETF	264.375	264.89	263.76	264.14	7395566.0
2018-11-20 14:30:00	SPY	ETF	264.14	265.25	263.91	264.165	5817019.0
2018-11-20 15:00:00	SPY	ETF	264.17	265.0265	263.15	264.7215	9244582.0
2018-11-20 15:30:00	SPY	ETF	264.72	265.06	263.8	264.2	18649956.0
2018-11-20 16:00:00	SPY	ETF	264.19	264.2305	263.69	264.03	7255924.0
2018-11-20 16:30:00	SPY	ETF	264.04	264.23	263.57	263.65	612233.0
2018-11-20 17:00:00	SPY	ETF	263.7	263.9	263.68	263.7	152559.0
2018-11-20 17:30:00	SPY	ETF	263.75	264.12	263.47	263.95	148829.0
2018-11-20 18:00:00	SPY	ETF	263.82	263.82	263.18	263.5	145847.0
2018-11-20 18:30:00	SPY	ETF	263.48	263.57	263.28	263.57	64871.0
2018-11-20 19:00:00	SPY	ETF	263.6	264.24	263.58	264.19	117438.0
2018-11-20 19:30:00	SPY	ETF	264.2	264.29	263.95	264.12	76253.0
2018-11-20 04:00:00	QQQ	ETF	161.11	161.11	160.49	160.8	49897.0
2018-11-20 04:30:00	QQQ	ETF	160.82	161.15	160.79	160.84	21329.0
2018-11-20 05:00:00	QQQ	ETF	160.75	161.01	160.59	160.98	38793.0
2018-11-20 05:30:00	QQQ	ETF	161.0	161.0	160.45	160.66	69798.0
2018-11-20 06:00:00	QQQ	ETF	160.59	160.7	160.32	160.32	84702.0
2018-11-20 06:30:00	QQQ	ETF	160.32	161.14	160.19	160.97	75867.0
2018-11-20 07:00:00	QQQ	ETF	160.9	160.9	160.34	160.37	309594.0
2018-11-20 07:30:00	QQQ	ETF	160.38	160.52	159.62	159.66	483965.0
2018-11-20 08:00:00	QQQ	ETF	159.68	161.2	159.54	159.78	493200.0
2018-11-20 08:30:00	QQQ	ETF	159.76	159.78	158.73	158.87	705187.0
2018-11-20 09:00:00	QQQ	ETF	158.87	159.09	158.19	158.37	1655377.0
2018-11-20 09:30:00	QQQ	ETF	158.37	159.76	157.8	158.44	16664278.0
2018-11-20 10:00:00	QQQ	ETF	158.45	159.3	157.13	158.9699	12082685.0
2018-11-20 10:30:00	QQQ	ETF	158.97	161.11	158.63	161.03	8550090.0
2018-11-20 11:00:00	QQQ	ETF	161.02	161.15	159.63	159.71	6209375.0
2018-11-20 11:30:00	QQQ	ETF	159.71	161.18	159.7	160.82	4802668.0
2018-11-20 12:00:00	QQQ	ETF	160.82	161.38	160.18	160.88	3819856.0
2018-11-20 12:30:00	QQQ	ETF	160.88	161.11	159.83	159.91	2424806.0

> showing 50 of 18,100 rows — these rows as CSV

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