PREVIEW / etf_30min / 2019-10-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-07.parquet
  size:    506 KB
  rows:    17,505

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-10-07 04:00:00	SPY	ETF	293.35	293.35	292.92	293.04	40870.0
2019-10-07 04:30:00	SPY	ETF	293.02	293.14	292.88	292.93	10130.0
2019-10-07 05:00:00	SPY	ETF	293.0	293.12	292.9	292.97	6875.0
2019-10-07 05:30:00	SPY	ETF	292.97	293.12	292.92	293.0	14005.0
2019-10-07 06:00:00	SPY	ETF	293.03	293.45	292.96	293.44	14107.0
2019-10-07 06:30:00	SPY	ETF	293.41	294.01	293.38	293.97	61832.0
2019-10-07 07:00:00	SPY	ETF	293.99	294.0	293.68	293.76	91463.0
2019-10-07 07:30:00	SPY	ETF	293.77	293.98	293.64	293.68	106610.0
2019-10-07 08:00:00	SPY	ETF	293.74	294.0	292.97	293.7	160445.0
2019-10-07 08:30:00	SPY	ETF	293.7	293.77	293.58	293.59	145336.0
2019-10-07 09:00:00	SPY	ETF	293.6	293.71	293.5	293.5	246926.0
2019-10-07 09:30:00	SPY	ETF	293.47	293.743	292.77	293.16	5280909.0
2019-10-07 10:00:00	SPY	ETF	293.16	293.885	292.9995	293.78	2661264.0
2019-10-07 10:30:00	SPY	ETF	293.78	294.16	293.45	294.07	2854514.0
2019-10-07 11:00:00	SPY	ETF	294.08	294.57	294.021	294.35	3917528.0
2019-10-07 11:30:00	SPY	ETF	294.34	294.84	294.3	294.83	3262398.0
2019-10-07 12:00:00	SPY	ETF	294.82	294.83	294.2638	294.3064	1528402.0
2019-10-07 12:30:00	SPY	ETF	294.31	294.54	294.15	294.34	1543517.0
2019-10-07 13:00:00	SPY	ETF	294.33	294.56	293.77	294.11	2046331.0
2019-10-07 13:30:00	SPY	ETF	294.11	295.26	294.07	295.15	5070543.0
2019-10-07 14:00:00	SPY	ETF	295.15	295.21	294.085	294.3	3933132.0
2019-10-07 14:30:00	SPY	ETF	294.2885	294.2885	293.23	293.74	5039583.0
2019-10-07 15:00:00	SPY	ETF	293.75	294.16	293.5689	294.01	3599241.0
2019-10-07 15:30:00	SPY	ETF	294.01	294.04	293.01	293.11	10433251.0
2019-10-07 16:00:00	SPY	ETF	293.12	293.16	292.85	293.1	6196705.0
2019-10-07 16:30:00	SPY	ETF	293.11	293.14	292.85	292.95	916841.0
2019-10-07 17:00:00	SPY	ETF	292.95	293.01	292.93	292.93	60788.0
2019-10-07 17:30:00	SPY	ETF	292.95	292.99	292.88	292.88	13296.0
2019-10-07 18:00:00	SPY	ETF	292.88	293.01	292.74	292.97	58170.0
2019-10-07 18:30:00	SPY	ETF	292.98	293.1	292.98	293.07	18383.0
2019-10-07 19:00:00	SPY	ETF	293.0	293.11	292.94	293.1	6750.0
2019-10-07 19:30:00	SPY	ETF	293.01	293.12	292.95	293.04	22154.0
2019-10-07 04:00:00	QQQ	ETF	188.17	188.17	187.99	188.07	21975.0
2019-10-07 04:30:00	QQQ	ETF	188.01	188.09	188.01	188.02	2054.0
2019-10-07 05:00:00	QQQ	ETF	187.97	188.01	187.93	187.98	5400.0
2019-10-07 05:30:00	QQQ	ETF	187.91	188.05	187.91	188.02	5130.0
2019-10-07 06:00:00	QQQ	ETF	188.02	188.31	187.98	188.28	11330.0
2019-10-07 06:30:00	QQQ	ETF	188.3	188.72	188.27	188.72	21345.0
2019-10-07 07:00:00	QQQ	ETF	188.72	188.72	188.47	188.52	33347.0
2019-10-07 07:30:00	QQQ	ETF	188.54	188.67	188.4	188.41	46371.0
2019-10-07 08:00:00	QQQ	ETF	188.67	188.72	188.02	188.48	58910.0
2019-10-07 08:30:00	QQQ	ETF	188.45	188.4999	188.27	188.31	44470.0
2019-10-07 09:00:00	QQQ	ETF	188.3	188.43	188.23	188.23	99565.0
2019-10-07 09:30:00	QQQ	ETF	188.23	188.69	187.91	188.27	2351000.0
2019-10-07 10:00:00	QQQ	ETF	188.28	188.87	188.06	188.78	902922.0
2019-10-07 10:30:00	QQQ	ETF	188.79	189.09	188.53	189.025	775311.0
2019-10-07 11:00:00	QQQ	ETF	189.04	189.42	189.0	189.06	1215232.0
2019-10-07 11:30:00	QQQ	ETF	189.07	189.44	189.02	189.4338	590013.0
2019-10-07 12:00:00	QQQ	ETF	189.43	189.44	188.96	189.01	469452.0
2019-10-07 12:30:00	QQQ	ETF	189.0	189.19	188.889	189.0	393001.0

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

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