PREVIEW / etf_1hour / 2021-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-05.parquet
  size:    427 KB
  rows:    14,973

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
2021-10-05 04:00:00	SPY	ETF	428.43	429.91	428.25	429.88	42076.0
2021-10-05 05:00:00	SPY	ETF	429.87	430.52	429.8	430.52	67337.0
2021-10-05 06:00:00	SPY	ETF	430.53	430.53	429.84	430.14	27643.0
2021-10-05 07:00:00	SPY	ETF	430.14	430.97	430.05	430.6	286724.0
2021-10-05 08:00:00	SPY	ETF	430.1396	430.98	428.64	430.7	340436.0
2021-10-05 09:00:00	SPY	ETF	430.71	431.739	429.39	431.27	9909088.0
2021-10-05 10:00:00	SPY	ETF	431.25	434.51	431.17	434.4759	14262980.0
2021-10-05 11:00:00	SPY	ETF	434.47	435.18	433.78	434.535	8649131.0
2021-10-05 12:00:00	SPY	ETF	434.54	435.17	433.85	434.51	5974282.0
2021-10-05 13:00:00	SPY	ETF	434.51	435.26	434.08	435.0001	5690760.0
2021-10-05 14:00:00	SPY	ETF	435.0	435.49	434.66	434.965	6663922.0
2021-10-05 15:00:00	SPY	ETF	434.97	435.335	432.85	433.05	15698905.0
2021-10-05 16:00:00	SPY	ETF	433.06	433.31	432.66	433.11	3628320.0
2021-10-05 17:00:00	SPY	ETF	433.18	433.18	433.0	433.04	67595.0
2021-10-05 18:00:00	SPY	ETF	433.01	433.44	433.0	433.29	113621.0
2021-10-05 19:00:00	SPY	ETF	433.32	433.32	432.29	432.4	171936.0
2021-10-05 04:00:00	QQQ	ETF	352.82	354.26	352.78	354.23	96236.0
2021-10-05 05:00:00	QQQ	ETF	354.26	354.7	354.21	354.5	88677.0
2021-10-05 06:00:00	QQQ	ETF	354.6	354.6	353.61	353.92	149913.0
2021-10-05 07:00:00	QQQ	ETF	353.9	354.53	353.45	354.07	262422.0
2021-10-05 08:00:00	QQQ	ETF	353.89	354.5004	352.7	354.0	304166.0
2021-10-05 09:00:00	QQQ	ETF	354.0	355.91	353.44	355.52	6451506.0
2021-10-05 10:00:00	QQQ	ETF	355.51	357.89	355.39	357.8699	7782066.0
2021-10-05 11:00:00	QQQ	ETF	357.85	358.669	357.505	358.37	5840926.0
2021-10-05 12:00:00	QQQ	ETF	358.39	359.17	358.07	358.93	3771944.0
2021-10-05 13:00:00	QQQ	ETF	358.93	359.4799	358.47	359.32	3023867.0
2021-10-05 14:00:00	QQQ	ETF	359.33	359.69	358.93	359.19	3125280.0
2021-10-05 15:00:00	QQQ	ETF	359.19	359.5374	357.23	357.38	6648130.0
2021-10-05 16:00:00	QQQ	ETF	357.38	357.6	357.07	357.44	1564207.0
2021-10-05 17:00:00	QQQ	ETF	357.5	357.59	357.15	357.44	97166.0
2021-10-05 18:00:00	QQQ	ETF	357.44	357.77	357.41	357.7	118521.0
2021-10-05 19:00:00	QQQ	ETF	357.71	357.73	356.81	356.88	97928.0
2021-10-05 04:00:00	IWM	ETF	219.67	220.65	219.52	220.6	18830.0
2021-10-05 05:00:00	IWM	ETF	220.67	221.04	220.67	220.98	11259.0
2021-10-05 06:00:00	IWM	ETF	221.05	221.08	220.76	220.83	12489.0
2021-10-05 07:00:00	IWM	ETF	220.81	221.5	220.8	221.36	101899.0
2021-10-05 08:00:00	IWM	ETF	221.03	221.42	219.53	221.2	59222.0
2021-10-05 09:00:00	IWM	ETF	221.31	221.56	219.88	220.84	3218663.0
2021-10-05 10:00:00	IWM	ETF	220.87	222.74	220.86	222.68	2733529.0
2021-10-05 11:00:00	IWM	ETF	222.66	223.06	221.145	221.4775	2091502.0
2021-10-05 12:00:00	IWM	ETF	221.465	221.69	220.21	220.93	2004160.0
2021-10-05 13:00:00	IWM	ETF	220.915	221.33	220.58	221.24	1017695.0
2021-10-05 14:00:00	IWM	ETF	221.25	221.64	221.02	221.38	1040435.0
2021-10-05 15:00:00	IWM	ETF	221.38	221.66	220.93	221.03	2569082.0
2021-10-05 16:00:00	IWM	ETF	221.02	221.31	220.88	221.02	1431605.0
2021-10-05 17:00:00	IWM	ETF	220.96	221.08	220.67	220.85	112594.0
2021-10-05 18:00:00	IWM	ETF	220.87	221.19	220.82	221.14	85802.0
2021-10-05 19:00:00	IWM	ETF	221.09	221.13	220.51	220.6	42015.0
2021-10-05 04:00:00	DIA	ETF	339.97	340.79	339.97	340.79	2141.0
2021-10-05 05:00:00	DIA	ETF	341.13	341.34	341.13	341.34	1000.0

> showing 50 of 14,973 rows — these rows as CSV

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