PREVIEW / etf_30min / 2022-12-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-21.parquet
  size:    697 KB
  rows:    28,122

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-12-21 04:00:00	SPY	ETF	382.41	383.16	382.41	383.09	8898.0
2022-12-21 04:30:00	SPY	ETF	383.07	383.22	382.8	383.17	17037.0
2022-12-21 05:00:00	SPY	ETF	383.2	383.21	382.78	383.06	17630.0
2022-12-21 05:30:00	SPY	ETF	383.1	383.1	382.35	382.51	22005.0
2022-12-21 06:00:00	SPY	ETF	382.44	382.6	382.33	382.38	33422.0
2022-12-21 06:30:00	SPY	ETF	382.38	382.87	382.25	382.82	21103.0
2022-12-21 07:00:00	SPY	ETF	382.77	382.87	381.88	382.15	126423.0
2022-12-21 07:30:00	SPY	ETF	382.18	383.09	382.09	383.04	109748.0
2022-12-21 08:00:00	SPY	ETF	382.4673	383.75	381.65	383.43	258844.0
2022-12-21 08:30:00	SPY	ETF	383.42	383.96	383.3	383.65	135138.0
2022-12-21 09:00:00	SPY	ETF	383.67	383.68	383.04	383.28	279118.0
2022-12-21 09:30:00	SPY	ETF	383.25	383.98	382.69	383.16	4743587.0
2022-12-21 10:00:00	SPY	ETF	383.17	385.22	382.88	385.15	4895181.0
2022-12-21 10:30:00	SPY	ETF	385.15	386.63	385.0	386.58	4957077.0
2022-12-21 11:00:00	SPY	ETF	386.58	387.3	386.055	386.46	4034571.0
2022-12-21 11:30:00	SPY	ETF	386.46	386.8297	385.6	385.94	2732843.0
2022-12-21 12:00:00	SPY	ETF	385.953	386.05	385.41	385.645	2220083.0
2022-12-21 12:30:00	SPY	ETF	385.6389	386.44	385.63	386.3899	1664649.0
2022-12-21 13:00:00	SPY	ETF	386.4082	386.82	385.63	385.745	2391036.0
2022-12-21 13:30:00	SPY	ETF	385.74	386.56	385.71	386.38	1649609.0
2022-12-21 14:00:00	SPY	ETF	386.39	387.41	386.3899	386.45	2979327.0
2022-12-21 14:30:00	SPY	ETF	386.47	386.87	385.73	386.09	2789828.0
2022-12-21 15:00:00	SPY	ETF	386.11	386.47	385.54	385.56	3017862.0
2022-12-21 15:30:00	SPY	ETF	385.56	386.29	385.24	386.23	7318216.0
2022-12-21 16:00:00	SPY	ETF	386.22	387.01	386.08	386.88	5522477.0
2022-12-21 16:30:00	SPY	ETF	386.92	386.99	386.2141	386.88	1645441.0
2022-12-21 17:00:00	SPY	ETF	386.94	387.11	386.85	386.93	45589.0
2022-12-21 17:30:00	SPY	ETF	386.93	386.95	386.83	386.9	20685.0
2022-12-21 18:00:00	SPY	ETF	386.94	387.06	386.61	386.66	45058.0
2022-12-21 18:30:00	SPY	ETF	386.61	386.95	386.23	386.65	20794.0
2022-12-21 19:00:00	SPY	ETF	386.61	386.71	386.4	386.6	37229.0
2022-12-21 19:30:00	SPY	ETF	386.58	386.93	386.35	386.89	54741.0
2022-12-21 04:00:00	QQQ	ETF	271.09	271.55	271.0	271.46	19287.0
2022-12-21 04:30:00	QQQ	ETF	271.42	271.52	271.22	271.4	20657.0
2022-12-21 05:00:00	QQQ	ETF	271.41	271.41	271.1	271.2	31842.0
2022-12-21 05:30:00	QQQ	ETF	271.23	271.25	270.61	270.71	61229.0
2022-12-21 06:00:00	QQQ	ETF	270.66	270.87	270.43	270.57	29761.0
2022-12-21 06:30:00	QQQ	ETF	270.45	270.79	270.3	270.68	39450.0
2022-12-21 07:00:00	QQQ	ETF	270.69	270.81	269.93	270.1	170568.0
2022-12-21 07:30:00	QQQ	ETF	270.13	271.0	270.1	270.9	156231.0
2022-12-21 08:00:00	QQQ	ETF	270.77	271.4496	269.742	271.04	300998.0
2022-12-21 08:30:00	QQQ	ETF	271.07	271.34	270.8	271.07	213756.0
2022-12-21 09:00:00	QQQ	ETF	271.09	271.1	270.52	270.57	221645.0
2022-12-21 09:30:00	QQQ	ETF	270.6	271.98	269.74	270.86	4947223.0
2022-12-21 10:00:00	QQQ	ETF	270.9	272.68	270.66	272.43	3147077.0
2022-12-21 10:30:00	QQQ	ETF	272.43	273.8583	272.23	273.83	2786214.0
2022-12-21 11:00:00	QQQ	ETF	273.85	274.48	273.33	273.7	2237812.0
2022-12-21 11:30:00	QQQ	ETF	273.7	274.12	272.9	273.3101	1843484.0
2022-12-21 12:00:00	QQQ	ETF	273.36	273.37	272.7	273.03	1399066.0
2022-12-21 12:30:00	QQQ	ETF	273.025	273.97	273.02	273.92	1457651.0

> showing 50 of 28,122 rows — these rows as CSV

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