PREVIEW / etf_30min / 2023-03-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-20.parquet
  size:    686 KB
  rows:    27,931

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
2023-03-20 04:00:00	SPY	ETF	387.49	389.0	385.18	386.03	81619.0
2023-03-20 04:30:00	SPY	ETF	386.07	388.33	385.96	388.28	104882.0
2023-03-20 05:00:00	SPY	ETF	388.41	389.6	388.0	388.33	102181.0
2023-03-20 05:30:00	SPY	ETF	388.68	390.08	388.68	389.86	84781.0
2023-03-20 06:00:00	SPY	ETF	389.86	390.65	389.3	389.92	122299.0
2023-03-20 06:30:00	SPY	ETF	389.63	390.81	389.52	390.61	144312.0
2023-03-20 07:00:00	SPY	ETF	390.56	390.79	389.45	390.29	146831.0
2023-03-20 07:30:00	SPY	ETF	390.34	390.66	389.11	389.9	200561.0
2023-03-20 08:00:00	SPY	ETF	389.9099	390.81	385.68	390.09	422187.0
2023-03-20 08:30:00	SPY	ETF	390.15	391.9	390.1	391.31	562458.0
2023-03-20 09:00:00	SPY	ETF	391.33	391.71	390.6	390.79	596929.0
2023-03-20 09:30:00	SPY	ETF	390.78	392.13	390.07	391.68	8678906.0
2023-03-20 10:00:00	SPY	ETF	391.68	392.69	390.9	392.37	5998936.0
2023-03-20 10:30:00	SPY	ETF	392.37	393.18	391.78	393.04	4649611.0
2023-03-20 11:00:00	SPY	ETF	393.04	394.17	392.72	394.04	4854859.0
2023-03-20 11:30:00	SPY	ETF	394.05	394.145	392.365	392.45	4350374.0
2023-03-20 12:00:00	SPY	ETF	392.45	392.67	390.73	391.798	6397562.0
2023-03-20 12:30:00	SPY	ETF	391.8	393.22	391.675	392.9	3422905.0
2023-03-20 13:00:00	SPY	ETF	392.9	393.84	392.85	393.26	3865096.0
2023-03-20 13:30:00	SPY	ETF	393.26	393.68	392.77	393.02	2711859.0
2023-03-20 14:00:00	SPY	ETF	393.01	393.33	392.35	392.98	3355479.0
2023-03-20 14:30:00	SPY	ETF	392.99	393.35	391.95	392.71	4203585.0
2023-03-20 15:00:00	SPY	ETF	392.7	393.15	392.255	392.96	4661481.0
2023-03-20 15:30:00	SPY	ETF	392.95	394.1278	392.83	393.66	9982023.0
2023-03-20 16:00:00	SPY	ETF	393.66	393.86	393.54	393.64	2831872.0
2023-03-20 16:30:00	SPY	ETF	393.65	394.01	393.65	393.93	178055.0
2023-03-20 17:00:00	SPY	ETF	393.97	394.02	393.93	394.0	29937.0
2023-03-20 17:30:00	SPY	ETF	393.99	394.07	393.74	393.96	366431.0
2023-03-20 18:00:00	SPY	ETF	393.97	394.04	393.61	393.95	49426.0
2023-03-20 18:30:00	SPY	ETF	393.96	394.09	393.77	393.94	55644.0
2023-03-20 19:00:00	SPY	ETF	393.9	393.9	393.61	393.64	40307.0
2023-03-20 19:30:00	SPY	ETF	393.65	393.69	393.5	393.68	59253.0
2023-03-20 04:00:00	QQQ	ETF	304.0	304.0	301.58	302.54	68837.0
2023-03-20 04:30:00	QQQ	ETF	302.58	304.14	302.44	304.03	32446.0
2023-03-20 05:00:00	QQQ	ETF	304.23	305.0	303.92	304.14	44118.0
2023-03-20 05:30:00	QQQ	ETF	304.33	305.19	304.33	304.91	23883.0
2023-03-20 06:00:00	QQQ	ETF	304.91	305.7	304.66	304.98	38754.0
2023-03-20 06:30:00	QQQ	ETF	304.98	305.4	304.85	305.16	85649.0
2023-03-20 07:00:00	QQQ	ETF	305.13	305.18	304.28	304.95	99020.0
2023-03-20 07:30:00	QQQ	ETF	304.93	305.27	304.09	304.65	127104.0
2023-03-20 08:00:00	QQQ	ETF	304.49	305.69	302.1596	304.73	269733.0
2023-03-20 08:30:00	QQQ	ETF	304.79	305.86	304.68	305.4698	313290.0
2023-03-20 09:00:00	QQQ	ETF	305.5	305.52	304.24	304.33	410803.0
2023-03-20 09:30:00	QQQ	ETF	304.26	304.5	302.01	302.81	7188784.0
2023-03-20 10:00:00	QQQ	ETF	302.82	304.035	302.59	303.85	4277766.0
2023-03-20 10:30:00	QQQ	ETF	303.83	304.93	303.32	304.77	2833465.0
2023-03-20 11:00:00	QQQ	ETF	304.77	305.99	304.62	305.911	2706503.0
2023-03-20 11:30:00	QQQ	ETF	305.93	306.0494	304.03	304.09	2356855.0
2023-03-20 12:00:00	QQQ	ETF	304.09	304.32	302.85	303.79	2511298.0
2023-03-20 12:30:00	QQQ	ETF	303.785	304.94	303.555	304.5749	2249133.0

> showing 50 of 27,931 rows — these rows as CSV

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