PREVIEW / etf_30min / 2020-04-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-16.parquet
  size:    586 KB
  rows:    21,520

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-04-16 04:00:00	SPY	ETF	279.89	280.26	279.55	279.73	68088.0
2020-04-16 04:30:00	SPY	ETF	279.71	280.0	279.35	279.39	18207.0
2020-04-16 05:00:00	SPY	ETF	279.17	279.19	278.59	278.59	38193.0
2020-04-16 05:30:00	SPY	ETF	278.59	279.52	278.59	279.25	49928.0
2020-04-16 06:00:00	SPY	ETF	279.28	279.62	278.4	279.62	59585.0
2020-04-16 06:30:00	SPY	ETF	279.71	279.74	279.0	279.16	88563.0
2020-04-16 07:00:00	SPY	ETF	279.2	279.25	278.73	279.08	171039.0
2020-04-16 07:30:00	SPY	ETF	279.19	279.24	277.89	278.3	257597.0
2020-04-16 08:00:00	SPY	ETF	279.02	280.7	276.32	278.26	626113.0
2020-04-16 08:30:00	SPY	ETF	278.26	280.23	278.26	279.15	1555209.0
2020-04-16 09:00:00	SPY	ETF	279.08	279.64	278.76	279.07	458594.0
2020-04-16 09:30:00	SPY	ETF	279.15	279.7393	276.69	276.8167	10206683.0
2020-04-16 10:00:00	SPY	ETF	276.81	277.5132	275.76	277.43	8415768.0
2020-04-16 10:30:00	SPY	ETF	277.43	278.63	276.685	278.52	8145188.0
2020-04-16 11:00:00	SPY	ETF	278.51	279.59	278.18	278.94	10180595.0
2020-04-16 11:30:00	SPY	ETF	278.94	280.03	278.25	279.72	5259042.0
2020-04-16 12:00:00	SPY	ETF	279.72	279.99	276.8	277.16	9460511.0
2020-04-16 12:30:00	SPY	ETF	277.16	277.47	275.84	277.27	9730066.0
2020-04-16 13:00:00	SPY	ETF	277.27	277.855	276.99	277.78	5881815.0
2020-04-16 13:30:00	SPY	ETF	277.78	278.2	277.08	277.4401	6404454.0
2020-04-16 14:00:00	SPY	ETF	277.48	278.66	276.8	278.0507	7860603.0
2020-04-16 14:30:00	SPY	ETF	278.077	279.0	277.69	278.34	4199221.0
2020-04-16 15:00:00	SPY	ETF	278.31	278.85	277.54	278.8	7257079.0
2020-04-16 15:30:00	SPY	ETF	278.83	279.98	278.61	279.21	16343542.0
2020-04-16 16:00:00	SPY	ETF	279.16	279.42	278.89	279.12	5092052.0
2020-04-16 16:30:00	SPY	ETF	279.16	283.4	279.16	283.3	2672203.0
2020-04-16 17:00:00	SPY	ETF	283.23	286.9	279.1	286.59	2065236.0
2020-04-16 17:30:00	SPY	ETF	286.54	289.4	279.1	286.8	2590629.0
2020-04-16 18:00:00	SPY	ETF	286.8	287.1	285.55	286.75	2479907.0
2020-04-16 18:30:00	SPY	ETF	286.8	288.5	286.26	288.06	1415098.0
2020-04-16 19:00:00	SPY	ETF	288.05	289.07	287.95	288.26	1141427.0
2020-04-16 19:30:00	SPY	ETF	288.25	288.34	286.56	287.5	604559.0
2020-04-16 04:00:00	QQQ	ETF	211.43	212.0	211.43	211.66	79733.0
2020-04-16 04:30:00	QQQ	ETF	211.64	211.79	211.41	211.47	15634.0
2020-04-16 05:00:00	QQQ	ETF	211.48	211.48	210.89	211.01	15381.0
2020-04-16 05:30:00	QQQ	ETF	211.01	211.63	211.01	211.36	35749.0
2020-04-16 06:00:00	QQQ	ETF	211.47	211.8	210.78	211.8	13662.0
2020-04-16 06:30:00	QQQ	ETF	211.76	211.8	211.48	211.62	39396.0
2020-04-16 07:00:00	QQQ	ETF	211.56	211.56	211.2	211.36	138839.0
2020-04-16 07:30:00	QQQ	ETF	211.41	211.47	210.5	210.81	112134.0
2020-04-16 08:00:00	QQQ	ETF	211.42	211.79	208.68	211.0	146923.0
2020-04-16 08:30:00	QQQ	ETF	211.12	212.25	211.12	211.83	520915.0
2020-04-16 09:00:00	QQQ	ETF	211.81	212.2	211.64	211.74	236448.0
2020-04-16 09:30:00	QQQ	ETF	211.74	212.25	210.82	210.89	5815387.0
2020-04-16 10:00:00	QQQ	ETF	210.89	211.46	209.69	211.4199	4334331.0
2020-04-16 10:30:00	QQQ	ETF	211.42	212.63	210.91	212.44	4283581.0
2020-04-16 11:00:00	QQQ	ETF	212.44	213.94	212.13	213.635	4527694.0
2020-04-16 11:30:00	QQQ	ETF	213.63	214.3	212.96	214.08	3452424.0
2020-04-16 12:00:00	QQQ	ETF	214.075	214.369	211.35	211.6499	4183775.0
2020-04-16 12:30:00	QQQ	ETF	211.66	211.67	210.02	211.42	3928524.0

> showing 50 of 21,520 rows — these rows as CSV

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