PREVIEW / etf_30min / 2022-08-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-26.parquet
  size:    657 KB
  rows:    26,124

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-26 04:00:00	SPY	ETF	419.1	419.1	418.04	418.04	18663.0
2022-08-26 04:30:00	SPY	ETF	418.01	418.56	417.86	418.22	41830.0
2022-08-26 05:00:00	SPY	ETF	418.13	418.31	417.87	418.02	11918.0
2022-08-26 05:30:00	SPY	ETF	417.92	418.07	417.7	417.86	22075.0
2022-08-26 06:00:00	SPY	ETF	417.86	418.13	417.75	418.02	39076.0
2022-08-26 06:30:00	SPY	ETF	418.02	418.02	417.59	417.75	125321.0
2022-08-26 07:00:00	SPY	ETF	417.84	417.9	417.39	417.83	66750.0
2022-08-26 07:30:00	SPY	ETF	417.74	418.52	417.72	418.32	44964.0
2022-08-26 08:00:00	SPY	ETF	417.67	418.82	417.46	418.28	110094.0
2022-08-26 08:30:00	SPY	ETF	418.23	419.5	417.95	419.45	351481.0
2022-08-26 09:00:00	SPY	ETF	419.45	421.02	419.35	419.45	729253.0
2022-08-26 09:30:00	SPY	ETF	419.39	419.59	418.05	419.17	4022197.0
2022-08-26 10:00:00	SPY	ETF	419.185	419.96	414.4	414.88	10005730.0
2022-08-26 10:30:00	SPY	ETF	414.9	414.9	411.95	412.7799	6529482.0
2022-08-26 11:00:00	SPY	ETF	412.76	412.86	410.06	411.2	5945724.0
2022-08-26 11:30:00	SPY	ETF	411.21	411.91	410.56	411.08	4377595.0
2022-08-26 12:00:00	SPY	ETF	411.08	411.13	409.51	409.98	3685273.0
2022-08-26 12:30:00	SPY	ETF	409.97	410.46	409.36	410.35	2709952.0
2022-08-26 13:00:00	SPY	ETF	410.34	410.69	409.78	410.08	2087468.0
2022-08-26 13:30:00	SPY	ETF	410.0801	410.09	408.9	409.08	2399928.0
2022-08-26 14:00:00	SPY	ETF	409.08	409.33	408.04	408.4707	3508168.0
2022-08-26 14:30:00	SPY	ETF	408.4709	408.69	407.355	407.45	3542882.0
2022-08-26 15:00:00	SPY	ETF	407.44	407.95	406.74	407.12	5199305.0
2022-08-26 15:30:00	SPY	ETF	407.11	407.22	405.25	405.32	14807051.0
2022-08-26 16:00:00	SPY	ETF	405.31	405.36	404.34	404.92	5322054.0
2022-08-26 16:30:00	SPY	ETF	404.93	405.31	403.8	403.81	466484.0
2022-08-26 17:00:00	SPY	ETF	403.79	404.23	403.76	404.14	170010.0
2022-08-26 17:30:00	SPY	ETF	404.14	405.31	404.0	404.2	793999.0
2022-08-26 18:00:00	SPY	ETF	404.21	405.31	403.9	404.02	90491.0
2022-08-26 18:30:00	SPY	ETF	404.0	404.0	403.9	403.91	16590.0
2022-08-26 19:00:00	SPY	ETF	403.91	403.91	403.7	403.78	15043.0
2022-08-26 19:30:00	SPY	ETF	403.8	404.25	403.75	403.9	52807.0
2022-08-26 04:00:00	QQQ	ETF	319.98	319.98	318.89	319.03	34305.0
2022-08-26 04:30:00	QQQ	ETF	318.9	319.5	318.84	319.1	22771.0
2022-08-26 05:00:00	QQQ	ETF	319.07	319.11	318.8	318.93	15338.0
2022-08-26 05:30:00	QQQ	ETF	318.81	318.94	318.57	318.73	21222.0
2022-08-26 06:00:00	QQQ	ETF	318.8	319.03	318.59	318.98	32248.0
2022-08-26 06:30:00	QQQ	ETF	318.75	318.85	318.65	318.81	25586.0
2022-08-26 07:00:00	QQQ	ETF	318.88	319.49	318.4	318.88	76303.0
2022-08-26 07:30:00	QQQ	ETF	318.869	319.54	318.81	319.34	73247.0
2022-08-26 08:00:00	QQQ	ETF	318.93	320.82	318.4099	319.15	137004.0
2022-08-26 08:30:00	QQQ	ETF	319.11	320.74	318.85	320.54	562913.0
2022-08-26 09:00:00	QQQ	ETF	320.5299	322.03	320.2	320.24	813536.0
2022-08-26 09:30:00	QQQ	ETF	320.28	320.58	318.77	319.98	3265599.0
2022-08-26 10:00:00	QQQ	ETF	319.99	321.51	315.74	316.3899	9127445.0
2022-08-26 10:30:00	QQQ	ETF	316.33	316.33	313.52	314.0466	4945580.0
2022-08-26 11:00:00	QQQ	ETF	314.04	314.2	311.29	312.51	4780804.0
2022-08-26 11:30:00	QQQ	ETF	312.43	312.93	311.74	312.15	2882586.0
2022-08-26 12:00:00	QQQ	ETF	312.15	312.18	310.86	311.3699	2258949.0
2022-08-26 12:30:00	QQQ	ETF	311.36	312.06	310.9	311.94	1648824.0

> showing 50 of 26,124 rows — these rows as CSV

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