PREVIEW / etf_30min / 2022-03-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-22.parquet
  size:    675 KB
  rows:    26,401

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
2022-03-22 04:00:00	SPY	ETF	444.69	445.57	444.55	445.44	10501.0
2022-03-22 04:30:00	SPY	ETF	445.85	446.17	445.73	445.81	11913.0
2022-03-22 05:00:00	SPY	ETF	446.0	446.41	445.79	445.82	14413.0
2022-03-22 05:30:00	SPY	ETF	445.8	445.91	445.7	445.83	13069.0
2022-03-22 06:00:00	SPY	ETF	445.86	445.86	445.4	445.78	34243.0
2022-03-22 06:30:00	SPY	ETF	446.04	446.27	445.83	446.03	25510.0
2022-03-22 07:00:00	SPY	ETF	445.98	446.06	445.48	445.8	61322.0
2022-03-22 07:30:00	SPY	ETF	445.8	446.0	445.45	445.51	53651.0
2022-03-22 08:00:00	SPY	ETF	445.5201	446.0504	443.1	445.22	82011.0
2022-03-22 08:30:00	SPY	ETF	445.22	445.91	445.15	445.9	100846.0
2022-03-22 09:00:00	SPY	ETF	445.89	446.08	445.58	445.87	197410.0
2022-03-22 09:30:00	SPY	ETF	445.86	447.49	445.86	447.21	5735229.0
2022-03-22 10:00:00	SPY	ETF	447.21	448.76	447.21	448.57	4770233.0
2022-03-22 10:30:00	SPY	ETF	448.563	449.39	448.563	448.81	4097537.0
2022-03-22 11:00:00	SPY	ETF	448.84	449.7	448.22	449.4	4084654.0
2022-03-22 11:30:00	SPY	ETF	449.39	449.42	448.495	448.7	3174819.0
2022-03-22 12:00:00	SPY	ETF	448.695	449.17	447.92	448.11	3130925.0
2022-03-22 12:30:00	SPY	ETF	448.13	449.09	447.79	449.02	2542237.0
2022-03-22 13:00:00	SPY	ETF	449.01	449.55	448.56	449.0155	2477531.0
2022-03-22 13:30:00	SPY	ETF	449.03	449.6	448.94	449.505	1935744.0
2022-03-22 14:00:00	SPY	ETF	449.51	449.59	448.12	448.585	3171935.0
2022-03-22 14:30:00	SPY	ETF	448.58	449.28	448.14	448.98	2713333.0
2022-03-22 15:00:00	SPY	ETF	448.98	449.86	448.81	449.03	3214946.0
2022-03-22 15:30:00	SPY	ETF	449.04	450.58	448.875	449.58	12079814.0
2022-03-22 16:00:00	SPY	ETF	449.58	449.82	449.437	449.62	4219217.0
2022-03-22 16:30:00	SPY	ETF	449.58	449.74	449.58	449.63	24272.0
2022-03-22 17:00:00	SPY	ETF	449.63	449.67	449.32	449.59	40114.0
2022-03-22 17:30:00	SPY	ETF	449.45	449.59	449.44	449.5	12706.0
2022-03-22 18:00:00	SPY	ETF	449.53	449.7	449.0	449.7	48587.0
2022-03-22 18:30:00	SPY	ETF	449.6504	450.27	449.61	450.01	32584.0
2022-03-22 19:00:00	SPY	ETF	450.01	450.09	449.8	449.87	9962.0
2022-03-22 19:30:00	SPY	ETF	449.82	450.13	449.8	450.08	29286.0
2022-03-22 04:00:00	QQQ	ETF	350.4	351.34	350.32	351.33	63474.0
2022-03-22 04:30:00	QQQ	ETF	351.53	351.8	351.36	351.58	27430.0
2022-03-22 05:00:00	QQQ	ETF	351.74	352.0	351.21	351.21	28444.0
2022-03-22 05:30:00	QQQ	ETF	351.2	351.45	351.15	351.26	22575.0
2022-03-22 06:00:00	QQQ	ETF	351.27	351.27	350.75	350.96	42242.0
2022-03-22 06:30:00	QQQ	ETF	351.3	351.67	351.13	351.42	24730.0
2022-03-22 07:00:00	QQQ	ETF	351.38	351.41	350.55	350.89	100834.0
2022-03-22 07:30:00	QQQ	ETF	350.91	351.115	350.4	350.48	125851.0
2022-03-22 08:00:00	QQQ	ETF	351.18	351.7304	348.8	350.26	247301.0
2022-03-22 08:30:00	QQQ	ETF	350.23	350.8	350.01	350.75	132023.0
2022-03-22 09:00:00	QQQ	ETF	350.75	350.93	350.3	350.55	189393.0
2022-03-22 09:30:00	QQQ	ETF	350.57	352.97	350.2	352.42	7359784.0
2022-03-22 10:00:00	QQQ	ETF	352.46	355.435	352.46	355.3188	4401693.0
2022-03-22 10:30:00	QQQ	ETF	355.34	356.52	355.34	355.97	3677252.0
2022-03-22 11:00:00	QQQ	ETF	355.99	357.7	355.5	357.43	3692469.0
2022-03-22 11:30:00	QQQ	ETF	357.42	357.43	356.22	356.24	2581925.0
2022-03-22 12:00:00	QQQ	ETF	356.25	356.7	354.99	355.4	3127706.0
2022-03-22 12:30:00	QQQ	ETF	355.41	356.15	354.95	355.919	2120679.0

> showing 50 of 26,401 rows — these rows as CSV

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