PREVIEW / etf_30min / 2019-09-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-27.parquet
  size:    500 KB
  rows:    17,360

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
2019-09-27 04:00:00	SPY	ETF	297.24	297.87	297.24	297.87	10154.0
2019-09-27 04:30:00	SPY	ETF	297.85	297.85	297.64	297.79	8450.0
2019-09-27 05:00:00	SPY	ETF	297.65	297.69	297.54	297.67	2801.0
2019-09-27 05:30:00	SPY	ETF	297.65	297.87	297.65	297.8	6031.0
2019-09-27 06:00:00	SPY	ETF	297.75	298.28	297.6	298.0	23014.0
2019-09-27 06:30:00	SPY	ETF	298.05	298.1	297.9	298.05	12250.0
2019-09-27 07:00:00	SPY	ETF	298.05	298.07	297.9	297.95	73822.0
2019-09-27 07:30:00	SPY	ETF	297.93	297.98	297.85	297.9	39989.0
2019-09-27 08:00:00	SPY	ETF	297.9	298.07	296.75	297.75	96656.0
2019-09-27 08:30:00	SPY	ETF	297.83	297.97	297.64	297.81	213264.0
2019-09-27 09:00:00	SPY	ETF	297.77	297.94	297.77	297.83	106967.0
2019-09-27 09:30:00	SPY	ETF	297.83	297.9465	296.7	296.89	4976374.0
2019-09-27 10:00:00	SPY	ETF	296.88	297.01	296.32	296.98	3053601.0
2019-09-27 10:30:00	SPY	ETF	296.98	297.69	296.76	297.6	2933425.0
2019-09-27 11:00:00	SPY	ETF	297.6	297.715	297.3	297.53	2556539.0
2019-09-27 11:30:00	SPY	ETF	297.53	297.64	295.28	296.64	10021713.0
2019-09-27 12:00:00	SPY	ETF	296.63	296.72	295.9	296.12	3663627.0
2019-09-27 12:30:00	SPY	ETF	296.1	296.23	294.91	294.91	3814809.0
2019-09-27 13:00:00	SPY	ETF	294.91	295.66	294.7	295.28	4715198.0
2019-09-27 13:30:00	SPY	ETF	295.285	295.44	294.65	295.23	2715203.0
2019-09-27 14:00:00	SPY	ETF	295.23	295.26	294.39	294.57	3051705.0
2019-09-27 14:30:00	SPY	ETF	294.57	294.63	293.69	293.98	5265962.0
2019-09-27 15:00:00	SPY	ETF	293.97	294.71	293.82	294.325	6592890.0
2019-09-27 15:30:00	SPY	ETF	294.32	295.46	294.27	295.36	14798614.0
2019-09-27 16:00:00	SPY	ETF	295.37	295.57	295.3166	295.54	9577376.0
2019-09-27 16:30:00	SPY	ETF	295.54	295.97	295.354	295.9	4960465.0
2019-09-27 17:00:00	SPY	ETF	295.9	296.8958	295.4	295.8	251952.0
2019-09-27 17:30:00	SPY	ETF	295.8	295.81	295.313	295.75	34137.0
2019-09-27 18:00:00	SPY	ETF	295.81	295.85	295.77	295.8	4538.0
2019-09-27 18:30:00	SPY	ETF	295.78	295.84	295.75	295.78	9690.0
2019-09-27 19:00:00	SPY	ETF	295.78	295.8	295.78	295.78	4466.0
2019-09-27 19:30:00	SPY	ETF	295.78	295.86	295.78	295.83	17410.0
2019-09-27 04:00:00	QQQ	ETF	189.42	189.6	189.37	189.6	9542.0
2019-09-27 04:30:00	QQQ	ETF	189.58	189.58	189.58	189.58	100.0
2019-09-27 05:00:00	QQQ	ETF	189.54	189.54	189.51	189.53	1670.0
2019-09-27 05:30:00	QQQ	ETF	189.54	189.71	189.54	189.66	6950.0
2019-09-27 06:00:00	QQQ	ETF	189.58	190.05	189.58	189.87	9500.0
2019-09-27 06:30:00	QQQ	ETF	189.9	189.92	189.79	189.79	13680.0
2019-09-27 07:00:00	QQQ	ETF	189.89	189.89	189.7	189.72	26364.0
2019-09-27 07:30:00	QQQ	ETF	189.72	189.78	189.64	189.69	16145.0
2019-09-27 08:00:00	QQQ	ETF	189.81	189.87	188.7	189.6	71166.0
2019-09-27 08:30:00	QQQ	ETF	189.72	189.79	189.5	189.65	69433.0
2019-09-27 09:00:00	QQQ	ETF	189.66	189.76	189.64	189.7	67569.0
2019-09-27 09:30:00	QQQ	ETF	189.68	189.83	188.46	188.63	3004342.0
2019-09-27 10:00:00	QQQ	ETF	188.62	188.74	188.21	188.72	1613048.0
2019-09-27 10:30:00	QQQ	ETF	188.72	189.29	188.47	189.23	1482334.0
2019-09-27 11:00:00	QQQ	ETF	189.23	189.43	189.11	189.31	961363.0
2019-09-27 11:30:00	QQQ	ETF	189.31	189.36	187.37	188.57	4557978.0
2019-09-27 12:00:00	QQQ	ETF	188.56	188.69	187.97	188.12	1409262.0
2019-09-27 12:30:00	QQQ	ETF	188.09	188.23	186.94	186.94	1923645.0

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

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