PREVIEW / etf_30min / 2020-09-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-03.parquet
  size:    607 KB
  rows:    22,661

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-09-03 04:00:00	SPY	ETF	358.08	358.36	357.97	358.0	60938.0
2020-09-03 04:30:00	SPY	ETF	357.93	357.96	357.55	357.71	29278.0
2020-09-03 05:00:00	SPY	ETF	357.56	357.6	357.08	357.34	34818.0
2020-09-03 05:30:00	SPY	ETF	357.29	357.4	356.61	356.61	25542.0
2020-09-03 06:00:00	SPY	ETF	356.68	356.87	356.5	356.81	122940.0
2020-09-03 06:30:00	SPY	ETF	356.89	356.93	356.3	356.42	146220.0
2020-09-03 07:00:00	SPY	ETF	356.35	356.75	356.14	356.23	171320.0
2020-09-03 07:30:00	SPY	ETF	356.25	356.74	356.14	356.55	248941.0
2020-09-03 08:00:00	SPY	ETF	356.59	357.93	355.99	356.31	363714.0
2020-09-03 08:30:00	SPY	ETF	356.34	356.95	356.2	356.29	470381.0
2020-09-03 09:00:00	SPY	ETF	356.25	358.056	355.72	355.89	404457.0
2020-09-03 09:30:00	SPY	ETF	355.87	356.38	355.16	355.8	7242084.0
2020-09-03 10:00:00	SPY	ETF	355.77	355.92	352.01	352.74	7378223.0
2020-09-03 10:30:00	SPY	ETF	352.74	353.15	350.3507	351.325	11354736.0
2020-09-03 11:00:00	SPY	ETF	351.33	351.48	345.201	347.28	18260023.0
2020-09-03 11:30:00	SPY	ETF	347.28	351.3105	346.511	348.05	11669267.0
2020-09-03 12:00:00	SPY	ETF	348.06	348.85	347.14	347.55	6790088.0
2020-09-03 12:30:00	SPY	ETF	347.5533	347.81	345.49	345.66	6631712.0
2020-09-03 13:00:00	SPY	ETF	345.65	346.98	344.26	346.92	8647766.0
2020-09-03 13:30:00	SPY	ETF	346.91	346.91	344.7	345.58	6609721.0
2020-09-03 14:00:00	SPY	ETF	345.59	346.4	344.6582	345.5201	6251751.0
2020-09-03 14:30:00	SPY	ETF	345.51	347.6	343.97	344.0	7330740.0
2020-09-03 15:00:00	SPY	ETF	344.0	344.66	342.79	342.91	9900543.0
2020-09-03 15:30:00	SPY	ETF	342.905	345.92	342.59	345.41	22251158.0
2020-09-03 16:00:00	SPY	ETF	345.42	346.85	345.39	346.12	8341279.0
2020-09-03 16:30:00	SPY	ETF	346.11	346.5	345.39	346.34	2960039.0
2020-09-03 17:00:00	SPY	ETF	346.28	346.37	345.39	345.86	1776657.0
2020-09-03 17:30:00	SPY	ETF	345.86	345.89	345.3	345.35	135468.0
2020-09-03 18:00:00	SPY	ETF	345.53	345.86	344.55	344.88	209535.0
2020-09-03 18:30:00	SPY	ETF	345.0	345.43	343.71	343.81	241596.0
2020-09-03 19:00:00	SPY	ETF	343.83	344.06	342.82	343.37	135457.0
2020-09-03 19:30:00	SPY	ETF	343.4	343.84	343.04	343.27	93448.0
2020-09-03 04:00:00	QQQ	ETF	302.12	302.3	301.8	302.0	31233.0
2020-09-03 04:30:00	QQQ	ETF	301.96	301.97	301.45	301.66	46180.0
2020-09-03 05:00:00	QQQ	ETF	301.64	301.64	300.6	300.91	42259.0
2020-09-03 05:30:00	QQQ	ETF	301.0	301.08	299.9	299.96	26432.0
2020-09-03 06:00:00	QQQ	ETF	299.99	300.32	299.79	300.24	31568.0
2020-09-03 06:30:00	QQQ	ETF	300.25	300.6	299.62	299.72	52516.0
2020-09-03 07:00:00	QQQ	ETF	299.75	300.28	299.24	299.33	291095.0
2020-09-03 07:30:00	QQQ	ETF	299.43	299.83	299.31	299.4	241495.0
2020-09-03 08:00:00	QQQ	ETF	299.48	302.16	298.95	299.35	255827.0
2020-09-03 08:30:00	QQQ	ETF	299.35	299.77	299.01	299.27	213582.0
2020-09-03 09:00:00	QQQ	ETF	299.27	299.27	298.12	298.26	430455.0
2020-09-03 09:30:00	QQQ	ETF	298.2	298.62	296.0	297.08	7601978.0
2020-09-03 10:00:00	QQQ	ETF	297.06	297.79	293.52	294.21	6379421.0
2020-09-03 10:30:00	QQQ	ETF	294.22	294.56	290.08	292.35	9160811.0
2020-09-03 11:00:00	QQQ	ETF	292.34	292.49	286.49	289.23	9663003.0
2020-09-03 11:30:00	QQQ	ETF	289.24	291.38	288.04	289.58	6342543.0
2020-09-03 12:00:00	QQQ	ETF	289.55	290.39	288.4245	288.7	3718413.0
2020-09-03 12:30:00	QQQ	ETF	288.6988	288.9	287.05	287.4	3519981.0

> showing 50 of 22,661 rows — these rows as CSV

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