PREVIEW / etf_30min / 2020-03-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-04.parquet
  size:    582 KB
  rows:    20,845

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
2020-03-04 04:00:00	SPY	ETF	304.99	305.71	304.75	305.32	122221.0
2020-03-04 04:30:00	SPY	ETF	305.24	306.3	305.15	305.82	98316.0
2020-03-04 05:00:00	SPY	ETF	305.65	306.43	305.59	306.23	30463.0
2020-03-04 05:30:00	SPY	ETF	306.24	306.25	305.57	305.69	33043.0
2020-03-04 06:00:00	SPY	ETF	305.86	305.89	305.18	305.7	38998.0
2020-03-04 06:30:00	SPY	ETF	305.66	306.3	305.66	306.21	175657.0
2020-03-04 07:00:00	SPY	ETF	306.19	307.38	305.67	307.14	635944.0
2020-03-04 07:30:00	SPY	ETF	307.1	307.6	306.18	306.22	565839.0
2020-03-04 08:00:00	SPY	ETF	306.9375	307.59	300.24	305.75	1841090.0
2020-03-04 08:30:00	SPY	ETF	305.72	306.5	305.36	305.75	584632.0
2020-03-04 09:00:00	SPY	ETF	305.75	306.31	305.1	306.09	797077.0
2020-03-04 09:30:00	SPY	ETF	306.12	307.27	303.33	304.23	19767737.0
2020-03-04 10:00:00	SPY	ETF	304.24	307.31	303.49	306.73	14726217.0
2020-03-04 10:30:00	SPY	ETF	306.76	306.89	304.34	304.72	11428559.0
2020-03-04 11:00:00	SPY	ETF	304.71	306.1934	304.06	306.19	10364715.0
2020-03-04 11:30:00	SPY	ETF	306.2	306.39	304.31	304.98	9816622.0
2020-03-04 12:00:00	SPY	ETF	304.9992	306.77	304.99	306.58	6963393.0
2020-03-04 12:30:00	SPY	ETF	306.58	307.97	305.91	307.895	5894815.0
2020-03-04 13:00:00	SPY	ETF	307.91	309.42	307.75	308.88	7730878.0
2020-03-04 13:30:00	SPY	ETF	308.89	309.46	308.47	308.98	5499026.0
2020-03-04 14:00:00	SPY	ETF	308.98	309.89	308.18	309.62	6547334.0
2020-03-04 14:30:00	SPY	ETF	309.63	310.0	308.65	309.37	8541941.0
2020-03-04 15:00:00	SPY	ETF	309.36	311.14	309.18	311.14	9306103.0
2020-03-04 15:30:00	SPY	ETF	311.15	313.1	310.7	312.91	30751107.0
2020-03-04 16:00:00	SPY	ETF	312.91	313.07	300.3723	311.4	17708553.0
2020-03-04 16:30:00	SPY	ETF	311.39	312.9958	310.85	311.34	2747970.0
2020-03-04 17:00:00	SPY	ETF	311.45	312.86	311.3	311.31	883391.0
2020-03-04 17:30:00	SPY	ETF	311.3699	311.5	311.25	311.3	102310.0
2020-03-04 18:00:00	SPY	ETF	311.2	311.51	310.47	310.48	313238.0
2020-03-04 18:30:00	SPY	ETF	310.45	310.94	310.16	310.91	115816.0
2020-03-04 19:00:00	SPY	ETF	310.79	310.79	309.92	310.55	179130.0
2020-03-04 19:30:00	SPY	ETF	310.52	311.03	310.23	310.33	99719.0
2020-03-04 04:00:00	QQQ	ETF	213.15	213.7	212.89	213.34	81356.0
2020-03-04 04:30:00	QQQ	ETF	213.26	214.0	213.17	213.81	61701.0
2020-03-04 05:00:00	QQQ	ETF	213.54	214.18	213.52	214.0	14638.0
2020-03-04 05:30:00	QQQ	ETF	214.0	214.03	213.48	213.64	19421.0
2020-03-04 06:00:00	QQQ	ETF	213.72	213.73	213.3	213.64	36371.0
2020-03-04 06:30:00	QQQ	ETF	213.66	213.91	213.58	213.79	68124.0
2020-03-04 07:00:00	QQQ	ETF	213.78	214.5	213.28	214.34	415390.0
2020-03-04 07:30:00	QQQ	ETF	214.33	214.88	213.98	214.0	176468.0
2020-03-04 08:00:00	QQQ	ETF	214.3202	214.85	209.48	213.26	703827.0
2020-03-04 08:30:00	QQQ	ETF	213.34	213.93	212.88	213.29	422551.0
2020-03-04 09:00:00	QQQ	ETF	213.33	213.79	212.91	213.32	816864.0
2020-03-04 09:30:00	QQQ	ETF	213.32	214.25	211.37	212.09	8720806.0
2020-03-04 10:00:00	QQQ	ETF	212.09	214.63	211.74	214.24	6921088.0
2020-03-04 10:30:00	QQQ	ETF	214.24	214.34	212.41	212.71	4288788.0
2020-03-04 11:00:00	QQQ	ETF	212.71	213.815	212.23	213.8	2965022.0
2020-03-04 11:30:00	QQQ	ETF	213.8	213.94	212.28	212.72	2817453.0
2020-03-04 12:00:00	QQQ	ETF	212.74	213.99	212.74	213.89	1963814.0
2020-03-04 12:30:00	QQQ	ETF	213.89	215.09	213.43	215.075	2179121.0

> showing 50 of 20,845 rows — these rows as CSV

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