PREVIEW / etf_30min / 2022-01-21

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-21.parquet
  size:    720 KB
  rows:    28,905

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-21 04:00:00	SPY	ETF	445.51	446.28	445.0	446.28	55121.0
2022-01-21 04:30:00	SPY	ETF	446.29	446.73	445.82	446.61	30944.0
2022-01-21 05:00:00	SPY	ETF	446.59	447.06	446.09	446.85	57013.0
2022-01-21 05:30:00	SPY	ETF	446.71	446.93	446.5	446.85	25613.0
2022-01-21 06:00:00	SPY	ETF	446.78	446.78	444.5	444.87	61814.0
2022-01-21 06:30:00	SPY	ETF	444.91	445.5	444.44	445.49	73444.0
2022-01-21 07:00:00	SPY	ETF	445.39	445.58	443.75	444.56	170511.0
2022-01-21 07:30:00	SPY	ETF	444.5	444.9	443.83	444.36	206904.0
2022-01-21 08:00:00	SPY	ETF	444.88	447.115	443.87	444.69	419050.0
2022-01-21 08:30:00	SPY	ETF	444.67	445.05	444.12	444.58	315134.0
2022-01-21 09:00:00	SPY	ETF	444.6	445.56	443.44	445.56	815216.0
2022-01-21 09:30:00	SPY	ETF	445.56	446.67	443.14	443.63	15544681.0
2022-01-21 10:00:00	SPY	ETF	443.64	444.31	440.66	442.8	15288684.0
2022-01-21 10:30:00	SPY	ETF	442.81	447.14	442.3611	446.09	12060094.0
2022-01-21 11:00:00	SPY	ETF	446.0899	448.06	445.13	447.45	7484706.0
2022-01-21 11:30:00	SPY	ETF	447.46	447.46	443.54	444.5	6103845.0
2022-01-21 12:00:00	SPY	ETF	444.5	445.02	442.88	443.58	5808109.0
2022-01-21 12:30:00	SPY	ETF	443.57	444.35	442.1	442.86	5416355.0
2022-01-21 13:00:00	SPY	ETF	442.85	444.23	441.49	442.02	6016119.0
2022-01-21 13:30:00	SPY	ETF	442.02	443.83	441.77	442.1805	4488853.0
2022-01-21 14:00:00	SPY	ETF	442.17	443.3	441.11	441.22	4646596.0
2022-01-21 14:30:00	SPY	ETF	441.23	442.295	439.85	439.95	7050034.0
2022-01-21 15:00:00	SPY	ETF	439.96	440.43	438.01	438.5	11631125.0
2022-01-21 15:30:00	SPY	ETF	438.505	441.26	437.97	438.02	24013330.0
2022-01-21 16:00:00	SPY	ETF	438.02	438.7	437.63	437.71	7361625.0
2022-01-21 16:30:00	SPY	ETF	437.74	437.98	437.61	437.61	2643787.0
2022-01-21 17:00:00	SPY	ETF	437.68	437.98	436.8	437.01	270172.0
2022-01-21 17:30:00	SPY	ETF	437.03	437.15	436.54	436.83	162694.0
2022-01-21 18:00:00	SPY	ETF	436.83	436.9	436.6	436.77	54403.0
2022-01-21 18:30:00	SPY	ETF	437.98	437.98	436.51	436.72	195778.0
2022-01-21 19:00:00	SPY	ETF	436.72	436.87	436.6	436.72	26238.0
2022-01-21 19:30:00	SPY	ETF	436.75	436.75	436.45	436.55	46722.0
2022-01-21 04:00:00	QQQ	ETF	361.71	362.0	359.04	360.12	101158.0
2022-01-21 04:30:00	QQQ	ETF	360.16	360.55	359.67	360.34	53660.0
2022-01-21 05:00:00	QQQ	ETF	360.32	361.09	359.97	360.9	52620.0
2022-01-21 05:30:00	QQQ	ETF	360.87	360.87	360.23	360.73	23389.0
2022-01-21 06:00:00	QQQ	ETF	360.59	360.59	358.35	358.79	154174.0
2022-01-21 06:30:00	QQQ	ETF	358.84	359.62	358.37	359.55	101077.0
2022-01-21 07:00:00	QQQ	ETF	359.47	359.53	357.88	358.71	153825.0
2022-01-21 07:30:00	QQQ	ETF	358.7	358.95	358.1	358.5	119194.0
2022-01-21 08:00:00	QQQ	ETF	358.08	361.991	356.95	358.89	487321.0
2022-01-21 08:30:00	QQQ	ETF	358.87	359.32	358.28	358.7	355522.0
2022-01-21 09:00:00	QQQ	ETF	358.71	359.5	357.72	359.42	674851.0
2022-01-21 09:30:00	QQQ	ETF	359.44	361.24	356.66	357.14	13091434.0
2022-01-21 10:00:00	QQQ	ETF	357.13	357.86	354.24	356.61	11314225.0
2022-01-21 10:30:00	QQQ	ETF	356.64	361.19	356.24	359.9	11335439.0
2022-01-21 11:00:00	QQQ	ETF	359.89	362.18	359.07	361.52	7203974.0
2022-01-21 11:30:00	QQQ	ETF	361.52	361.52	357.18	358.27	6203313.0
2022-01-21 12:00:00	QQQ	ETF	358.26	359.375	356.46	357.1034	5849542.0
2022-01-21 12:30:00	QQQ	ETF	357.09	358.08	356.03	356.97	5157464.0

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

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