PREVIEW / etf_30min / 2020-05-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-07.parquet
  size:    549 KB
  rows:    20,308

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-05-07 04:00:00	SPY	ETF	286.7	287.13	286.7	287.13	59490.0
2020-05-07 04:30:00	SPY	ETF	287.11	287.4	286.91	287.28	59597.0
2020-05-07 05:00:00	SPY	ETF	287.31	287.49	287.19	287.48	39516.0
2020-05-07 05:30:00	SPY	ETF	287.5	288.11	287.47	287.84	60509.0
2020-05-07 06:00:00	SPY	ETF	287.87	288.19	287.56	287.86	94471.0
2020-05-07 06:30:00	SPY	ETF	287.9	287.9	287.36	287.5	73485.0
2020-05-07 07:00:00	SPY	ETF	287.49	287.66	287.16	287.31	369952.0
2020-05-07 07:30:00	SPY	ETF	287.29	288.4	287.24	288.27	279305.0
2020-05-07 08:00:00	SPY	ETF	287.8999	288.3599	285.18	287.82	660348.0
2020-05-07 08:30:00	SPY	ETF	287.84	288.19	287.47	287.96	406153.0
2020-05-07 09:00:00	SPY	ETF	287.97	288.13	287.66	287.72	226012.0
2020-05-07 09:30:00	SPY	ETF	287.75	288.96	287.58	288.63	8784939.0
2020-05-07 10:00:00	SPY	ETF	288.63	288.73	287.2221	288.02	5238485.0
2020-05-07 10:30:00	SPY	ETF	288.02	288.63	287.39	287.62	4215679.0
2020-05-07 11:00:00	SPY	ETF	287.61	288.6784	287.58	288.52	5431046.0
2020-05-07 11:30:00	SPY	ETF	288.53	289.72	288.31	289.44	6532743.0
2020-05-07 12:00:00	SPY	ETF	289.435	289.78	289.16	289.45	4252247.0
2020-05-07 12:30:00	SPY	ETF	289.46	289.54	288.7799	289.2498	3417616.0
2020-05-07 13:00:00	SPY	ETF	289.2462	289.57	288.91	288.97	3532526.0
2020-05-07 13:30:00	SPY	ETF	288.965	289.305	288.51	288.82	3842024.0
2020-05-07 14:00:00	SPY	ETF	288.815	289.0	288.02	288.32	3437074.0
2020-05-07 14:30:00	SPY	ETF	288.315	289.52	287.62	288.06	3196978.0
2020-05-07 15:00:00	SPY	ETF	288.06	288.45	287.14	287.88	6785420.0
2020-05-07 15:30:00	SPY	ETF	287.9	287.98	287.13	287.7	10216761.0
2020-05-07 16:00:00	SPY	ETF	287.7	288.39	287.57	288.31	2294801.0
2020-05-07 16:30:00	SPY	ETF	288.3	288.75	287.68	288.58	548319.0
2020-05-07 17:00:00	SPY	ETF	288.58	288.62	288.41	288.42	123501.0
2020-05-07 17:30:00	SPY	ETF	288.42	288.53	287.68	288.48	41801.0
2020-05-07 18:00:00	SPY	ETF	288.48	289.02	288.34	288.97	110724.0
2020-05-07 18:30:00	SPY	ETF	288.96	289.14	288.92	289.07	97181.0
2020-05-07 19:00:00	SPY	ETF	289.19	289.25	288.65	288.7	106121.0
2020-05-07 19:30:00	SPY	ETF	288.7	289.56	288.66	289.51	145345.0
2020-05-07 04:00:00	QQQ	ETF	220.95	221.75	220.95	221.33	39567.0
2020-05-07 04:30:00	QQQ	ETF	221.42	221.6	221.3	221.56	8833.0
2020-05-07 05:00:00	QQQ	ETF	221.55	221.7	221.5	221.7	15350.0
2020-05-07 05:30:00	QQQ	ETF	221.72	222.06	221.72	221.97	24300.0
2020-05-07 06:00:00	QQQ	ETF	221.93	222.1	221.76	221.88	52850.0
2020-05-07 06:30:00	QQQ	ETF	221.87	221.87	221.52	221.57	27212.0
2020-05-07 07:00:00	QQQ	ETF	221.59	221.6	221.16	221.3	150594.0
2020-05-07 07:30:00	QQQ	ETF	221.28	222.07	221.28	221.9	138514.0
2020-05-07 08:00:00	QQQ	ETF	219.725	222.02	219.725	221.57	262075.0
2020-05-07 08:30:00	QQQ	ETF	221.62	221.9	219.725	221.8	138610.0
2020-05-07 09:00:00	QQQ	ETF	221.85	221.94	221.63	221.75	114324.0
2020-05-07 09:30:00	QQQ	ETF	221.76	222.28	221.08	221.73	5652236.0
2020-05-07 10:00:00	QQQ	ETF	221.71	221.86	220.67	221.345	3256990.0
2020-05-07 10:30:00	QQQ	ETF	221.35	221.54	220.42	220.7979	2387466.0
2020-05-07 11:00:00	QQQ	ETF	220.8	221.6597	220.8	221.44	2152196.0
2020-05-07 11:30:00	QQQ	ETF	221.43	222.35	221.33	222.01	3011500.0
2020-05-07 12:00:00	QQQ	ETF	222.0	222.47	221.91	222.33	1237623.0
2020-05-07 12:30:00	QQQ	ETF	222.32	222.4599	222.08	222.42	1337200.0

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

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