PREVIEW / etf_30min / 2023-03-31

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-31.parquet
  size:    702 KB
  rows:    27,707

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-31 04:00:00	SPY	ETF	403.81	403.87	403.53	403.78	10533.0
2023-03-31 04:30:00	SPY	ETF	403.76	404.06	403.73	403.81	3541.0
2023-03-31 05:00:00	SPY	ETF	403.87	404.36	403.82	404.32	7359.0
2023-03-31 05:30:00	SPY	ETF	404.44	404.53	404.17	404.32	4959.0
2023-03-31 06:00:00	SPY	ETF	404.27	404.31	404.13	404.3	2448.0
2023-03-31 06:30:00	SPY	ETF	404.43	404.45	404.3	404.36	15698.0
2023-03-31 07:00:00	SPY	ETF	404.39	404.56	404.28	404.52	48568.0
2023-03-31 07:30:00	SPY	ETF	404.57	404.69	404.27	404.27	58395.0
2023-03-31 08:00:00	SPY	ETF	404.38	404.99	403.6796	404.64	218680.0
2023-03-31 08:30:00	SPY	ETF	404.36	405.45	403.9	404.77	660423.0
2023-03-31 09:00:00	SPY	ETF	404.79	405.16	404.61	404.66	347225.0
2023-03-31 09:30:00	SPY	ETF	404.65	405.77	404.55	405.46	7701329.0
2023-03-31 10:00:00	SPY	ETF	405.49	405.99	405.36	405.6599	5172103.0
2023-03-31 10:30:00	SPY	ETF	405.66	406.31	405.5597	406.19	4565095.0
2023-03-31 11:00:00	SPY	ETF	406.19	407.04	406.0375	406.705	3866750.0
2023-03-31 11:30:00	SPY	ETF	406.71	407.16	406.65	407.13	2929749.0
2023-03-31 12:00:00	SPY	ETF	407.12	407.69	407.06	407.57	3199865.0
2023-03-31 12:30:00	SPY	ETF	407.57	407.635	407.05	407.2294	2680157.0
2023-03-31 13:00:00	SPY	ETF	407.23	407.36	406.89	407.0	2736476.0
2023-03-31 13:30:00	SPY	ETF	407.01	407.25	406.68	407.13	3015797.0
2023-03-31 14:00:00	SPY	ETF	407.14	407.71	406.94	407.225	3791304.0
2023-03-31 14:30:00	SPY	ETF	407.22	407.59	407.03	407.54	3100667.0
2023-03-31 15:00:00	SPY	ETF	407.53	409.085	407.5299	408.9614	6883516.0
2023-03-31 15:30:00	SPY	ETF	408.96	409.7	408.04	409.36	19393357.0
2023-03-31 16:00:00	SPY	ETF	409.37	409.57	409.18	409.48	6587445.0
2023-03-31 16:30:00	SPY	ETF	409.49	409.75	409.39	409.52	349184.0
2023-03-31 17:00:00	SPY	ETF	409.52	409.65	409.51	409.62	41704.0
2023-03-31 17:30:00	SPY	ETF	409.63	409.69	409.5	409.52	38897.0
2023-03-31 18:00:00	SPY	ETF	409.52	409.6	409.46	409.58	58600.0
2023-03-31 18:30:00	SPY	ETF	409.63	409.69	409.6	409.69	2903.0
2023-03-31 19:00:00	SPY	ETF	409.62	409.62	409.58	409.6	1691.0
2023-03-31 19:30:00	SPY	ETF	409.61	409.85	409.61	409.76	30045.0
2023-03-31 04:00:00	QQQ	ETF	315.97	316.01	315.53	315.7	20276.0
2023-03-31 04:30:00	QQQ	ETF	315.68	315.78	315.58	315.65	5717.0
2023-03-31 05:00:00	QQQ	ETF	315.7	316.0	315.57	315.87	12819.0
2023-03-31 05:30:00	QQQ	ETF	315.89	315.94	315.57	315.63	9945.0
2023-03-31 06:00:00	QQQ	ETF	315.54	315.54	315.41	315.44	3291.0
2023-03-31 06:30:00	QQQ	ETF	315.48	315.58	315.38	315.47	4949.0
2023-03-31 07:00:00	QQQ	ETF	315.6	315.86	315.53	315.8	59413.0
2023-03-31 07:30:00	QQQ	ETF	315.8	315.86	315.5	315.53	46396.0
2023-03-31 08:00:00	QQQ	ETF	315.51	316.75	315.21	315.56	215908.0
2023-03-31 08:30:00	QQQ	ETF	315.5	316.78	315.1	316.03	896557.0
2023-03-31 09:00:00	QQQ	ETF	316.0401	316.57	315.95	315.95	301591.0
2023-03-31 09:30:00	QQQ	ETF	315.91	317.67	315.6	317.11	4964787.0
2023-03-31 10:00:00	QQQ	ETF	317.11	317.56	316.81	317.2599	3086018.0
2023-03-31 10:30:00	QQQ	ETF	317.25	318.2499	317.18	317.9	3806583.0
2023-03-31 11:00:00	QQQ	ETF	317.91	318.46	317.69	318.1489	1942153.0
2023-03-31 11:30:00	QQQ	ETF	318.15	318.8	318.07	318.7696	1917785.0
2023-03-31 12:00:00	QQQ	ETF	318.77	319.345	318.63	319.312	2264650.0
2023-03-31 12:30:00	QQQ	ETF	319.305	319.416	319.065	319.12	2088479.0

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

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