PREVIEW / etf_30min / 2022-12-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-13.parquet
  size:    711 KB
  rows:    28,977

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-13 04:00:00	SPY	ETF	398.9	399.64	398.9	399.64	43035.0
2022-12-13 04:30:00	SPY	ETF	399.7	400.27	399.48	399.81	65334.0
2022-12-13 05:00:00	SPY	ETF	399.75	400.34	399.37	400.25	13253.0
2022-12-13 05:30:00	SPY	ETF	400.29	400.75	400.2	400.63	13188.0
2022-12-13 06:00:00	SPY	ETF	400.68	400.96	400.45	400.93	25533.0
2022-12-13 06:30:00	SPY	ETF	401.0	401.3	400.75	401.02	49061.0
2022-12-13 07:00:00	SPY	ETF	400.97	401.16	400.66	401.06	103502.0
2022-12-13 07:30:00	SPY	ETF	400.99	401.81	400.99	401.72	141576.0
2022-12-13 08:00:00	SPY	ETF	400.89	407.5	398.8	406.3	913479.0
2022-12-13 08:30:00	SPY	ETF	406.321	414.1	405.55	410.55	6035109.0
2022-12-13 09:00:00	SPY	ETF	410.6	411.6	409.95	410.2	1398883.0
2022-12-13 09:30:00	SPY	ETF	410.21	410.49	407.4	409.33	11449369.0
2022-12-13 10:00:00	SPY	ETF	409.36	409.54	404.85	405.48	8887665.0
2022-12-13 10:30:00	SPY	ETF	405.48	406.16	403.63	404.41	7212956.0
2022-12-13 11:00:00	SPY	ETF	404.43	405.53	403.87	404.57	4654563.0
2022-12-13 11:30:00	SPY	ETF	404.59	405.84	401.73	402.65	5484741.0
2022-12-13 12:00:00	SPY	ETF	402.67	403.23	399.89	400.27	5699092.0
2022-12-13 12:30:00	SPY	ETF	400.25	400.87	399.07	400.0112	5678976.0
2022-12-13 13:00:00	SPY	ETF	400.02	402.08	399.78	401.83	4142752.0
2022-12-13 13:30:00	SPY	ETF	401.84	402.39	400.62	401.64	3249987.0
2022-12-13 14:00:00	SPY	ETF	401.64	402.1	400.9	401.7	2965635.0
2022-12-13 14:30:00	SPY	ETF	401.7	403.22	401.13	401.59	3360953.0
2022-12-13 15:00:00	SPY	ETF	401.58	401.82	399.88	401.72	4465927.0
2022-12-13 15:30:00	SPY	ETF	401.73	403.04	401.31	401.95	13280795.0
2022-12-13 16:00:00	SPY	ETF	401.96	402.25	401.5	401.85	3448129.0
2022-12-13 16:30:00	SPY	ETF	401.85	402.15	401.75	401.75	259611.0
2022-12-13 17:00:00	SPY	ETF	401.89	401.9	401.73	401.85	41548.0
2022-12-13 17:30:00	SPY	ETF	401.85	401.85	401.743	401.81	19927.0
2022-12-13 18:00:00	SPY	ETF	401.85	402.3	401.81	401.96	56535.0
2022-12-13 18:30:00	SPY	ETF	402.02	402.1	401.85	401.96	30880.0
2022-12-13 19:00:00	SPY	ETF	401.85	402.1	401.62	401.73	34601.0
2022-12-13 19:30:00	SPY	ETF	401.71	402.69	401.7	402.6	93973.0
2022-12-13 04:00:00	QQQ	ETF	285.74	286.31	285.68	286.31	73296.0
2022-12-13 04:30:00	QQQ	ETF	286.33	286.81	286.15	286.2	19182.0
2022-12-13 05:00:00	QQQ	ETF	286.24	286.8	286.07	286.7	5753.0
2022-12-13 05:30:00	QQQ	ETF	286.69	287.12	286.69	287.03	13427.0
2022-12-13 06:00:00	QQQ	ETF	287.07	287.19	286.82	287.19	19006.0
2022-12-13 06:30:00	QQQ	ETF	287.17	287.24	286.95	287.05	25048.0
2022-12-13 07:00:00	QQQ	ETF	287.05	287.27	286.7	287.11	35340.0
2022-12-13 07:30:00	QQQ	ETF	287.16	287.89	287.16	287.8	96327.0
2022-12-13 08:00:00	QQQ	ETF	287.3746	292.5	285.22	292.0	818310.0
2022-12-13 08:30:00	QQQ	ETF	292.39	300.8	291.2	296.58	4873740.0
2022-12-13 09:00:00	QQQ	ETF	296.6	297.65	296.2	296.62	1948037.0
2022-12-13 09:30:00	QQQ	ETF	296.63	296.875	294.06	295.77	9082938.0
2022-12-13 10:00:00	QQQ	ETF	295.8	295.92	292.01	292.44	6588885.0
2022-12-13 10:30:00	QQQ	ETF	292.46	292.94	290.7	291.89	4589868.0
2022-12-13 11:00:00	QQQ	ETF	291.94	292.93	291.32	291.911	2820121.0
2022-12-13 11:30:00	QQQ	ETF	291.92	292.97	288.97	289.68	3977156.0
2022-12-13 12:00:00	QQQ	ETF	289.69	290.02	286.6	286.92	4479494.0
2022-12-13 12:30:00	QQQ	ETF	286.94	287.53	285.91	287.2	4009428.0

> showing 50 of 28,977 rows — these rows as CSV

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