PREVIEW / etf_30min / 2022-12-12

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-12.parquet
  size:    679 KB
  rows:    27,064

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-12-12 04:00:00	SPY	ETF	393.16	393.34	392.95	393.18	28737.0
2022-12-12 04:30:00	SPY	ETF	393.16	394.06	393.16	394.06	12599.0
2022-12-12 05:00:00	SPY	ETF	394.03	394.25	393.98	394.07	28279.0
2022-12-12 05:30:00	SPY	ETF	394.08	394.52	394.04	394.43	15236.0
2022-12-12 06:00:00	SPY	ETF	394.2	394.61	394.2	394.52	14999.0
2022-12-12 06:30:00	SPY	ETF	394.56	394.62	394.28	394.38	48631.0
2022-12-12 07:00:00	SPY	ETF	394.41	394.5	394.24	394.28	73846.0
2022-12-12 07:30:00	SPY	ETF	394.29	394.49	394.28	394.39	39573.0
2022-12-12 08:00:00	SPY	ETF	394.4	394.75	392.78	394.43	157842.0
2022-12-12 08:30:00	SPY	ETF	394.43	394.83	394.05	394.24	124707.0
2022-12-12 09:00:00	SPY	ETF	394.23	394.56	393.99	394.1	293266.0
2022-12-12 09:30:00	SPY	ETF	394.1	394.76	393.412	394.6327	4954805.0
2022-12-12 10:00:00	SPY	ETF	394.64	394.87	393.81	394.44	3508263.0
2022-12-12 10:30:00	SPY	ETF	394.465	394.71	394.0	394.52	2092852.0
2022-12-12 11:00:00	SPY	ETF	394.53	395.69	394.34	395.33	3324283.0
2022-12-12 11:30:00	SPY	ETF	395.335	395.4616	394.89	395.416	1549508.0
2022-12-12 12:00:00	SPY	ETF	395.42	395.83	395.12	395.36	1610953.0
2022-12-12 12:30:00	SPY	ETF	395.36	395.92	395.23	395.73	1954674.0
2022-12-12 13:00:00	SPY	ETF	395.73	396.25	395.08	395.47	2044718.0
2022-12-12 13:30:00	SPY	ETF	395.46	396.14	395.4	395.8699	2038084.0
2022-12-12 14:00:00	SPY	ETF	395.87	395.985	395.385	395.76	2352269.0
2022-12-12 14:30:00	SPY	ETF	395.77	396.88	395.47	396.735	2933092.0
2022-12-12 15:00:00	SPY	ETF	396.75	398.246	396.75	398.075	4960064.0
2022-12-12 15:30:00	SPY	ETF	398.08	398.93	397.87	398.91	9738571.0
2022-12-12 16:00:00	SPY	ETF	398.92	398.95	398.24	398.39	10072037.0
2022-12-12 16:30:00	SPY	ETF	398.37	398.95	398.21	398.41	250727.0
2022-12-12 17:00:00	SPY	ETF	398.41	398.53	398.25	398.49	76576.0
2022-12-12 17:30:00	SPY	ETF	398.5	398.68	398.46	398.55	79579.0
2022-12-12 18:00:00	SPY	ETF	398.54	398.67	398.46	398.56	73197.0
2022-12-12 18:30:00	SPY	ETF	398.57	398.9	398.46	398.6795	35726.0
2022-12-12 19:00:00	SPY	ETF	398.74	398.98	398.74	398.84	24552.0
2022-12-12 19:30:00	SPY	ETF	398.79	398.8399	398.6	398.76	31600.0
2022-12-12 04:00:00	QQQ	ETF	282.07	282.22	281.95	282.07	40104.0
2022-12-12 04:30:00	QQQ	ETF	282.05	282.7	282.05	282.7	29674.0
2022-12-12 05:00:00	QQQ	ETF	282.8	282.83	282.57	282.69	9949.0
2022-12-12 05:30:00	QQQ	ETF	282.7	283.13	282.67	282.98	7744.0
2022-12-12 06:00:00	QQQ	ETF	283.05	283.12	282.83	282.97	12019.0
2022-12-12 06:30:00	QQQ	ETF	282.99	283.15	282.88	282.9	10328.0
2022-12-12 07:00:00	QQQ	ETF	282.99	283.05	282.67	282.68	55562.0
2022-12-12 07:30:00	QQQ	ETF	282.7	282.87	282.66	282.71	25112.0
2022-12-12 08:00:00	QQQ	ETF	282.7199	283.1304	281.52	282.74	137643.0
2022-12-12 08:30:00	QQQ	ETF	282.78	283.15	282.53	282.66	170105.0
2022-12-12 09:00:00	QQQ	ETF	282.65	282.76	282.15	282.21	391881.0
2022-12-12 09:30:00	QQQ	ETF	282.21	283.0236	281.42	282.7096	4437135.0
2022-12-12 10:00:00	QQQ	ETF	282.71	282.7799	281.72	282.2	2524220.0
2022-12-12 10:30:00	QQQ	ETF	282.205	282.21	281.16	281.84	2095560.0
2022-12-12 11:00:00	QQQ	ETF	281.86	282.89	281.7419	282.405	2140723.0
2022-12-12 11:30:00	QQQ	ETF	282.41	282.69	281.95	282.52	1291053.0
2022-12-12 12:00:00	QQQ	ETF	282.51	282.82	282.24	282.44	1188430.0
2022-12-12 12:30:00	QQQ	ETF	282.44	282.84	282.34	282.75	1170462.0

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

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