PREVIEW / etf_30min / 2022-05-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-06.parquet
  size:    684 KB
  rows:    27,490

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-05-06 04:00:00	SPY	ETF	412.58	413.26	411.99	413.24	25311.0
2022-05-06 04:30:00	SPY	ETF	413.2	413.88	412.07	412.58	16846.0
2022-05-06 05:00:00	SPY	ETF	412.36	412.58	411.4	411.5	24975.0
2022-05-06 05:30:00	SPY	ETF	411.46	413.06	411.46	413.06	23850.0
2022-05-06 06:00:00	SPY	ETF	413.04	413.04	412.04	412.9	13558.0
2022-05-06 06:30:00	SPY	ETF	412.99	413.3	411.98	412.35	29351.0
2022-05-06 07:00:00	SPY	ETF	412.38	412.38	411.0	411.2	171691.0
2022-05-06 07:30:00	SPY	ETF	411.19	411.94	410.73	411.84	234308.0
2022-05-06 08:00:00	SPY	ETF	412.05	413.7696	410.76	412.35	307385.0
2022-05-06 08:30:00	SPY	ETF	412.7	414.64	410.62	410.8	1344915.0
2022-05-06 09:00:00	SPY	ETF	410.82	411.75	410.28	411.08	739902.0
2022-05-06 09:30:00	SPY	ETF	411.1	411.77	405.73	406.3616	15892335.0
2022-05-06 10:00:00	SPY	ETF	406.35	411.61	405.75	409.46	13951160.0
2022-05-06 10:30:00	SPY	ETF	409.49	413.48	407.64	412.77	8534295.0
2022-05-06 11:00:00	SPY	ETF	412.735	414.8	411.08	413.73	6654081.0
2022-05-06 11:30:00	SPY	ETF	413.75	413.96	409.5301	409.89	6484452.0
2022-05-06 12:00:00	SPY	ETF	409.88	413.12	409.53	411.81	5118801.0
2022-05-06 12:30:00	SPY	ETF	411.85	413.98	410.85	413.79	4048893.0
2022-05-06 13:00:00	SPY	ETF	413.79	414.36	411.0	412.07	5166366.0
2022-05-06 13:30:00	SPY	ETF	412.06	412.94	409.79	410.11	4622314.0
2022-05-06 14:00:00	SPY	ETF	410.11	410.75	408.3228	408.77	5549675.0
2022-05-06 14:30:00	SPY	ETF	408.73	410.64	407.8	408.9399	6263178.0
2022-05-06 15:00:00	SPY	ETF	408.915	409.44	407.36	408.625	6303949.0
2022-05-06 15:30:00	SPY	ETF	408.63	412.98	408.57	411.38	16386371.0
2022-05-06 16:00:00	SPY	ETF	411.38	411.53	409.82	410.31	3902739.0
2022-05-06 16:30:00	SPY	ETF	410.26	411.34	410.17	410.66	386772.0
2022-05-06 17:00:00	SPY	ETF	410.39	411.01	410.3	410.78	119770.0
2022-05-06 17:30:00	SPY	ETF	410.8	410.95	410.51	410.51	32384.0
2022-05-06 18:00:00	SPY	ETF	410.6	410.69	410.4	410.4	6692.0
2022-05-06 18:30:00	SPY	ETF	410.57	410.89	410.31	410.67	29380.0
2022-05-06 19:00:00	SPY	ETF	410.64	410.8	410.55	410.68	19388.0
2022-05-06 19:30:00	SPY	ETF	410.52	411.0	410.25	410.7	36565.0
2022-05-06 04:00:00	QQQ	ETF	311.66	312.91	311.66	312.74	108629.0
2022-05-06 04:30:00	QQQ	ETF	312.86	313.47	311.76	311.78	97075.0
2022-05-06 05:00:00	QQQ	ETF	311.8	312.12	311.13	311.34	20357.0
2022-05-06 05:30:00	QQQ	ETF	311.43	312.42	311.43	312.41	45438.0
2022-05-06 06:00:00	QQQ	ETF	312.36	312.5	311.56	312.28	69426.0
2022-05-06 06:30:00	QQQ	ETF	312.26	312.56	311.44	311.5	104391.0
2022-05-06 07:00:00	QQQ	ETF	311.69	311.77	310.52	310.62	131129.0
2022-05-06 07:30:00	QQQ	ETF	310.65	311.46	310.19	311.4	245681.0
2022-05-06 08:00:00	QQQ	ETF	311.31	313.234	310.2104	311.94	352350.0
2022-05-06 08:30:00	QQQ	ETF	311.94	314.2	309.94	310.09	1824155.0
2022-05-06 09:00:00	QQQ	ETF	310.08	311.25	309.74	310.89	894757.0
2022-05-06 09:30:00	QQQ	ETF	310.95	311.73	305.105	305.84	17592878.0
2022-05-06 10:00:00	QQQ	ETF	305.85	312.92	305.67	309.86	17906221.0
2022-05-06 10:30:00	QQQ	ETF	309.86	313.63	307.98	312.98	13077741.0
2022-05-06 11:00:00	QQQ	ETF	312.93	315.09	310.89	314.02	7080335.0
2022-05-06 11:30:00	QQQ	ETF	314.03	314.345	309.48	309.85	8321748.0
2022-05-06 12:00:00	QQQ	ETF	309.8699	313.115	309.5	311.72	5382082.0
2022-05-06 12:30:00	QQQ	ETF	311.72	313.56	310.64	313.47	5035189.0

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

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