PREVIEW / etf_30min / 2022-07-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-08.parquet
  size:    647 KB
  rows:    25,443

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-07-08 04:00:00	SPY	ETF	387.93	388.29	387.56	387.69	19278.0
2022-07-08 04:30:00	SPY	ETF	387.44	387.54	387.13	387.54	26011.0
2022-07-08 05:00:00	SPY	ETF	387.06	387.24	386.78	387.24	14229.0
2022-07-08 05:30:00	SPY	ETF	387.23	387.98	387.16	387.9	10017.0
2022-07-08 06:00:00	SPY	ETF	387.87	389.3	387.87	389.14	27251.0
2022-07-08 06:30:00	SPY	ETF	389.1	389.27	387.79	387.89	72918.0
2022-07-08 07:00:00	SPY	ETF	387.97	388.65	387.88	388.41	67852.0
2022-07-08 07:30:00	SPY	ETF	388.44	388.7	388.04	388.33	29098.0
2022-07-08 08:00:00	SPY	ETF	388.41	389.2404	387.0396	388.67	297785.0
2022-07-08 08:30:00	SPY	ETF	388.63	388.81	385.35	386.84	1808691.0
2022-07-08 09:00:00	SPY	ETF	386.86	387.36	386.56	387.18	426083.0
2022-07-08 09:30:00	SPY	ETF	387.27	388.54	385.8738	386.3	5925551.0
2022-07-08 10:00:00	SPY	ETF	386.33	389.34	385.66	389.1023	4699401.0
2022-07-08 10:30:00	SPY	ETF	389.11	389.83	388.68	389.51	4218239.0
2022-07-08 11:00:00	SPY	ETF	389.52	390.64	389.26	390.34	3054019.0
2022-07-08 11:30:00	SPY	ETF	390.38	390.6	389.0429	389.9425	2552188.0
2022-07-08 12:00:00	SPY	ETF	389.95	390.0	387.94	387.98	2868207.0
2022-07-08 12:30:00	SPY	ETF	387.98	388.1759	387.04	387.16	3137670.0
2022-07-08 13:00:00	SPY	ETF	387.18	388.36	386.66	388.2916	2538655.0
2022-07-08 13:30:00	SPY	ETF	388.3	389.06	387.9401	388.48	2193882.0
2022-07-08 14:00:00	SPY	ETF	388.48	389.65	388.1	389.5618	2389692.0
2022-07-08 14:30:00	SPY	ETF	389.57	390.23	389.29	390.02	3040393.0
2022-07-08 15:00:00	SPY	ETF	390.0299	390.35	389.35	389.545	2719138.0
2022-07-08 15:30:00	SPY	ETF	389.56	389.67	388.42	388.68	7312084.0
2022-07-08 16:00:00	SPY	ETF	388.68	389.08	388.42	389.0	3917112.0
2022-07-08 16:30:00	SPY	ETF	389.05	389.06	388.87	389.02	57167.0
2022-07-08 17:00:00	SPY	ETF	388.86	389.07	388.86	388.92	35546.0
2022-07-08 17:30:00	SPY	ETF	388.97	388.99	388.5	388.6	101287.0
2022-07-08 18:00:00	SPY	ETF	388.6	388.88	388.4	388.55	41415.0
2022-07-08 18:30:00	SPY	ETF	388.55	388.59	388.49	388.58	6102.0
2022-07-08 19:00:00	SPY	ETF	388.59	388.65	388.53	388.63	4849.0
2022-07-08 19:30:00	SPY	ETF	388.63	388.8	388.6	388.69	11155.0
2022-07-08 04:00:00	QQQ	ETF	294.0	294.25	293.69	293.69	33067.0
2022-07-08 04:30:00	QQQ	ETF	293.62	293.7	293.42	293.66	18603.0
2022-07-08 05:00:00	QQQ	ETF	293.37	293.37	292.91	293.27	25096.0
2022-07-08 05:30:00	QQQ	ETF	293.25	293.75	293.23	293.68	8358.0
2022-07-08 06:00:00	QQQ	ETF	293.7	294.63	293.69	294.5	28303.0
2022-07-08 06:30:00	QQQ	ETF	294.46	294.52	293.2	293.25	65706.0
2022-07-08 07:00:00	QQQ	ETF	293.34	293.9	293.31	293.71	83372.0
2022-07-08 07:30:00	QQQ	ETF	293.79	294.02	293.55	293.65	43474.0
2022-07-08 08:00:00	QQQ	ETF	293.7001	295.201	293.0704	293.99	324653.0
2022-07-08 08:30:00	QQQ	ETF	293.93	293.93	290.5	291.9	2522384.0
2022-07-08 09:00:00	QQQ	ETF	291.94	292.28	291.44	292.0	675878.0
2022-07-08 09:30:00	QQQ	ETF	292.08	293.87	291.12	291.78	7319386.0
2022-07-08 10:00:00	QQQ	ETF	291.8	294.67	291.28	294.5	4460057.0
2022-07-08 10:30:00	QQQ	ETF	294.51	295.4513	294.32	295.18	3552723.0
2022-07-08 11:00:00	QQQ	ETF	295.19	296.75	295.0	296.545	3844668.0
2022-07-08 11:30:00	QQQ	ETF	296.5599	296.72	295.2685	296.2	2515868.0
2022-07-08 12:00:00	QQQ	ETF	296.21	296.24	293.73	293.76	2968237.0
2022-07-08 12:30:00	QQQ	ETF	293.74	293.99	292.72	293.089	3056709.0

> showing 50 of 25,443 rows — these rows as CSV

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