PREVIEW / etf_30min / 2022-01-03

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-03.parquet
  size:    683 KB
  rows:    27,038

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-01-03 04:00:00	SPY	ETF	476.38	476.92	476.38	476.76	19228.0
2022-01-03 04:30:00	SPY	ETF	476.81	477.25	476.73	477.25	30682.0
2022-01-03 05:00:00	SPY	ETF	477.24	477.61	477.15	477.6	19864.0
2022-01-03 05:30:00	SPY	ETF	477.7	477.76	477.6	477.76	10991.0
2022-01-03 06:00:00	SPY	ETF	477.76	478.09	477.76	477.89	58818.0
2022-01-03 06:30:00	SPY	ETF	477.94	478.08	477.91	478.0	8759.0
2022-01-03 07:00:00	SPY	ETF	478.02	478.06	477.7	477.74	41129.0
2022-01-03 07:30:00	SPY	ETF	477.75	477.75	477.33	477.41	99234.0
2022-01-03 08:00:00	SPY	ETF	477.9504	477.99	476.84	477.45	250931.0
2022-01-03 08:30:00	SPY	ETF	477.45	477.5	476.53	476.56	236266.0
2022-01-03 09:00:00	SPY	ETF	476.53	476.85	476.23	476.34	273517.0
2022-01-03 09:30:00	SPY	ETF	476.32	477.72	473.85	474.9266	8557541.0
2022-01-03 10:00:00	SPY	ETF	474.94	476.76	474.77	476.75	4040306.0
2022-01-03 10:30:00	SPY	ETF	476.74	476.78	475.61	476.17	2566489.0
2022-01-03 11:00:00	SPY	ETF	476.16	476.25	475.05	475.53	2448659.0
2022-01-03 11:30:00	SPY	ETF	475.54	475.84	474.45	475.36	2507537.0
2022-01-03 12:00:00	SPY	ETF	475.32	475.995	475.03	475.93	1875873.0
2022-01-03 12:30:00	SPY	ETF	475.93	475.95	475.48	475.6	1231684.0
2022-01-03 13:00:00	SPY	ETF	475.6	476.185	475.335	476.0601	1720633.0
2022-01-03 13:30:00	SPY	ETF	476.085	476.77	475.87	476.74	1787993.0
2022-01-03 14:00:00	SPY	ETF	476.73	477.08	476.6	476.92	2327827.0
2022-01-03 14:30:00	SPY	ETF	476.92	477.68	476.73	477.228	2424261.0
2022-01-03 15:00:00	SPY	ETF	477.22	477.53	477.0001	477.3901	2490934.0
2022-01-03 15:30:00	SPY	ETF	477.4	477.85	476.65	477.76	10149250.0
2022-01-03 16:00:00	SPY	ETF	477.75	477.87	476.4299	477.73	4339942.0
2022-01-03 16:30:00	SPY	ETF	477.74	477.86	477.5	477.56	76174.0
2022-01-03 17:00:00	SPY	ETF	477.71	477.71	477.58	477.62	11167.0
2022-01-03 17:30:00	SPY	ETF	477.61	477.68	477.52	477.52	7501.0
2022-01-03 18:00:00	SPY	ETF	477.68	477.77	477.6	477.6	18596.0
2022-01-03 18:30:00	SPY	ETF	477.71	477.71	477.35	477.35	72151.0
2022-01-03 19:00:00	SPY	ETF	477.31	477.45	477.25	477.38	25460.0
2022-01-03 19:30:00	SPY	ETF	477.33	477.68	477.29	477.6	29270.0
2022-01-03 04:00:00	QQQ	ETF	399.04	399.56	399.04	399.4	30813.0
2022-01-03 04:30:00	QQQ	ETF	399.38	399.76	399.31	399.76	33820.0
2022-01-03 05:00:00	QQQ	ETF	399.74	400.13	399.68	400.08	48817.0
2022-01-03 05:30:00	QQQ	ETF	400.12	400.12	399.96	400.07	5887.0
2022-01-03 06:00:00	QQQ	ETF	400.15	400.7	400.15	400.5	23967.0
2022-01-03 06:30:00	QQQ	ETF	400.63	400.74	400.41	400.66	12165.0
2022-01-03 07:00:00	QQQ	ETF	400.6	400.65	400.23	400.33	58898.0
2022-01-03 07:30:00	QQQ	ETF	400.35	400.48	400.14	400.15	34574.0
2022-01-03 08:00:00	QQQ	ETF	400.45	400.5996	399.49	400.23	66316.0
2022-01-03 08:30:00	QQQ	ETF	400.22	400.26	399.11	399.1496	311695.0
2022-01-03 09:00:00	QQQ	ETF	399.12	399.41	398.8	399.11	363940.0
2022-01-03 09:30:00	QQQ	ETF	399.05	401.53	396.88	397.48	6756777.0
2022-01-03 10:00:00	QQQ	ETF	397.49	400.16	397.21	399.98	3720055.0
2022-01-03 10:30:00	QQQ	ETF	399.98	400.55	399.21	400.41	2254351.0
2022-01-03 11:00:00	QQQ	ETF	400.41	400.6	399.21	399.82	1744382.0
2022-01-03 11:30:00	QQQ	ETF	399.83	400.31	398.91	399.33	1832841.0
2022-01-03 12:00:00	QQQ	ETF	399.3214	400.08	398.9	399.9	1293850.0
2022-01-03 12:30:00	QQQ	ETF	399.92	400.29	399.63	400.03	1121110.0

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

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