PREVIEW / etf_30min / 2022-08-08

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-08.parquet
  size:    658 KB
  rows:    25,719

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-08-08 04:00:00	SPY	ETF	414.72	415.16	414.07	414.62	20172.0
2022-08-08 04:30:00	SPY	ETF	414.64	414.75	414.48	414.48	11578.0
2022-08-08 05:00:00	SPY	ETF	414.53	414.8	414.28	414.31	11454.0
2022-08-08 05:30:00	SPY	ETF	414.38	414.57	414.38	414.48	3250.0
2022-08-08 06:00:00	SPY	ETF	414.5	414.84	414.46	414.75	11051.0
2022-08-08 06:30:00	SPY	ETF	414.87	415.79	414.84	415.73	35641.0
2022-08-08 07:00:00	SPY	ETF	415.76	415.76	415.14	415.14	66561.0
2022-08-08 07:30:00	SPY	ETF	415.16	416.0	415.12	415.86	142452.0
2022-08-08 08:00:00	SPY	ETF	415.86	416.18	413.2	416.1	111935.0
2022-08-08 08:30:00	SPY	ETF	416.13	416.56	415.87	416.55	185798.0
2022-08-08 09:00:00	SPY	ETF	416.56	416.59	414.89	415.23	354373.0
2022-08-08 09:30:00	SPY	ETF	415.25	417.62	414.92	417.19	6185023.0
2022-08-08 10:00:00	SPY	ETF	417.19	417.62	416.23	416.71	3565453.0
2022-08-08 10:30:00	SPY	ETF	416.74	417.34	416.3	416.5	2410987.0
2022-08-08 11:00:00	SPY	ETF	416.51	417.11	415.54	415.69	2314640.0
2022-08-08 11:30:00	SPY	ETF	415.68	415.96	413.545	414.88	4056064.0
2022-08-08 12:00:00	SPY	ETF	414.84	415.01	412.47	412.77	3038193.0
2022-08-08 12:30:00	SPY	ETF	412.76	413.74	412.35	413.33	2189450.0
2022-08-08 13:00:00	SPY	ETF	413.3294	414.21	412.97	413.15	2082008.0
2022-08-08 13:30:00	SPY	ETF	413.16	414.0	412.9	413.9008	1276069.0
2022-08-08 14:00:00	SPY	ETF	413.919	413.9386	412.49	412.82	2063092.0
2022-08-08 14:30:00	SPY	ETF	412.81	412.99	411.83	412.5	2438489.0
2022-08-08 15:00:00	SPY	ETF	412.495	413.1086	412.06	412.77	1936297.0
2022-08-08 15:30:00	SPY	ETF	412.7799	413.39	412.42	413.02	4284182.0
2022-08-08 16:00:00	SPY	ETF	413.03	413.42	412.91	413.32	1845111.0
2022-08-08 16:30:00	SPY	ETF	413.31	413.97	413.31	413.9	159366.0
2022-08-08 17:00:00	SPY	ETF	413.9	414.05	413.76	413.97	83258.0
2022-08-08 17:30:00	SPY	ETF	413.97	413.99	413.64	413.64	38248.0
2022-08-08 18:00:00	SPY	ETF	413.7	413.78	413.5	413.56	60668.0
2022-08-08 18:30:00	SPY	ETF	413.52	413.57	413.42	413.47	16842.0
2022-08-08 19:00:00	SPY	ETF	413.5	414.12	413.35	414.11	48150.0
2022-08-08 19:30:00	SPY	ETF	414.11	414.32	414.0	414.13	48850.0
2022-08-08 04:00:00	QQQ	ETF	322.52	323.61	322.52	323.27	63828.0
2022-08-08 04:30:00	QQQ	ETF	323.3	323.47	323.13	323.24	12041.0
2022-08-08 05:00:00	QQQ	ETF	323.3	323.5	322.76	322.9	13924.0
2022-08-08 05:30:00	QQQ	ETF	322.98	323.04	322.84	323.01	11033.0
2022-08-08 06:00:00	QQQ	ETF	323.02	323.32	323.0	323.15	4286.0
2022-08-08 06:30:00	QQQ	ETF	323.15	324.18	323.15	324.14	74857.0
2022-08-08 07:00:00	QQQ	ETF	324.12	324.12	323.51	323.51	115236.0
2022-08-08 07:30:00	QQQ	ETF	323.5	324.31	323.46	324.14	75769.0
2022-08-08 08:00:00	QQQ	ETF	324.16	324.57	321.991	324.52	219105.0
2022-08-08 08:30:00	QQQ	ETF	324.55	324.79	324.09	324.74	173757.0
2022-08-08 09:00:00	QQQ	ETF	324.74	324.74	322.34	322.67	1307065.0
2022-08-08 09:30:00	QQQ	ETF	322.69	326.29	321.91	325.81	6240824.0
2022-08-08 10:00:00	QQQ	ETF	325.82	326.47	324.52	324.95	3389939.0
2022-08-08 10:30:00	QQQ	ETF	324.98	325.68	323.89	324.2	2376319.0
2022-08-08 11:00:00	QQQ	ETF	324.235	324.95	323.06	323.18	2049973.0
2022-08-08 11:30:00	QQQ	ETF	323.17	323.615	321.075	322.42	3389138.0
2022-08-08 12:00:00	QQQ	ETF	322.41	322.6282	320.17	320.48	2847878.0
2022-08-08 12:30:00	QQQ	ETF	320.45	321.58	320.14	321.0601	1873242.0

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

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