PREVIEW / etf_30min / 2023-04-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-12.parquet
  size:    693 KB
  rows:    27,903

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-04-12 04:00:00	SPY	ETF	409.91	410.48	409.9	410.21	15970.0
2023-04-12 04:30:00	SPY	ETF	410.2	410.25	410.07	410.07	3090.0
2023-04-12 05:00:00	SPY	ETF	409.97	410.17	409.92	410.11	6370.0
2023-04-12 05:30:00	SPY	ETF	410.16	410.5	410.13	410.43	6250.0
2023-04-12 06:00:00	SPY	ETF	410.48	410.67	410.39	410.48	8641.0
2023-04-12 06:30:00	SPY	ETF	410.47	410.5	410.26	410.26	11787.0
2023-04-12 07:00:00	SPY	ETF	410.29	410.38	410.12	410.2	51272.0
2023-04-12 07:30:00	SPY	ETF	410.19	410.63	410.13	410.61	103769.0
2023-04-12 08:00:00	SPY	ETF	410.61	410.6104	409.52	409.81	320520.0
2023-04-12 08:30:00	SPY	ETF	410.14	413.75	410.14	412.11	2274506.0
2023-04-12 09:00:00	SPY	ETF	412.12	412.43	411.58	411.85	732342.0
2023-04-12 09:30:00	SPY	ETF	411.87	412.17	410.14	410.75	7349715.0
2023-04-12 10:00:00	SPY	ETF	410.74	411.85	410.34	411.57	5171544.0
2023-04-12 10:30:00	SPY	ETF	411.55	411.7401	409.09	409.174	5559362.0
2023-04-12 11:00:00	SPY	ETF	409.18	409.6	408.23	409.5875	4777587.0
2023-04-12 11:30:00	SPY	ETF	409.58	410.47	409.26	410.34	3298479.0
2023-04-12 12:00:00	SPY	ETF	410.34	410.76	410.24	410.53	2888812.0
2023-04-12 12:30:00	SPY	ETF	410.53	410.97	410.24	410.86	1894716.0
2023-04-12 13:00:00	SPY	ETF	410.87	411.48	410.46	411.19	2735403.0
2023-04-12 13:30:00	SPY	ETF	411.19	411.48	410.64	410.8799	2163678.0
2023-04-12 14:00:00	SPY	ETF	410.879	411.48	409.43	409.63	4408089.0
2023-04-12 14:30:00	SPY	ETF	409.63	409.63	408.52	409.0211	5185696.0
2023-04-12 15:00:00	SPY	ETF	409.03	409.42	407.46	407.58	5087808.0
2023-04-12 15:30:00	SPY	ETF	407.59	408.49	407.44	408.07	11783029.0
2023-04-12 16:00:00	SPY	ETF	408.075	408.21	407.7	407.75	3814762.0
2023-04-12 16:30:00	SPY	ETF	407.77	408.05	407.71	407.77	433119.0
2023-04-12 17:00:00	SPY	ETF	407.86	407.92	407.61	407.7	28425.0
2023-04-12 17:30:00	SPY	ETF	407.7	408.05	407.6	407.79	252511.0
2023-04-12 18:00:00	SPY	ETF	407.79	407.82	407.55	407.61	27689.0
2023-04-12 18:30:00	SPY	ETF	407.61	407.61	407.22	407.32	68254.0
2023-04-12 19:00:00	SPY	ETF	407.34	407.5	407.28	407.44	36875.0
2023-04-12 19:30:00	SPY	ETF	407.43	407.56	407.15	407.2	18161.0
2023-04-12 04:00:00	QQQ	ETF	315.58	316.19	315.58	316.13	9808.0
2023-04-12 04:30:00	QQQ	ETF	316.05	316.07	315.79	315.81	10275.0
2023-04-12 05:00:00	QQQ	ETF	315.85	315.97	315.64	315.97	9649.0
2023-04-12 05:30:00	QQQ	ETF	316.01	316.25	315.98	316.19	17244.0
2023-04-12 06:00:00	QQQ	ETF	316.28	316.44	316.02	316.12	14110.0
2023-04-12 06:30:00	QQQ	ETF	316.0	316.05	315.71	315.71	6183.0
2023-04-12 07:00:00	QQQ	ETF	315.75	315.9	315.58	315.63	42302.0
2023-04-12 07:30:00	QQQ	ETF	315.63	316.3	315.63	316.24	53771.0
2023-04-12 08:00:00	QQQ	ETF	316.24	316.24	315.32	315.4	336768.0
2023-04-12 08:30:00	QQQ	ETF	315.35	319.85	315.35	318.22	2666791.0
2023-04-12 09:00:00	QQQ	ETF	318.27	318.62	317.6	317.8	855492.0
2023-04-12 09:30:00	QQQ	ETF	317.82	318.42	314.86	315.63	7264229.0
2023-04-12 10:00:00	QQQ	ETF	315.63	317.03	315.145	316.92	3919001.0
2023-04-12 10:30:00	QQQ	ETF	316.93	317.17	314.23	314.3	4282077.0
2023-04-12 11:00:00	QQQ	ETF	314.295	314.7796	313.5	314.7001	2873385.0
2023-04-12 11:30:00	QQQ	ETF	314.7	315.94	314.33	315.78	2208242.0
2023-04-12 12:00:00	QQQ	ETF	315.79	316.25	315.58	315.9	1785071.0
2023-04-12 12:30:00	QQQ	ETF	315.915	316.1993	315.58	316.1	1415217.0

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

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