PREVIEW / etf_1hour / 2021-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-12.parquet
  size:    413 KB
  rows:    14,468

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-12 04:00:00	SPY	ETF	433.47	434.37	432.75	434.31	42259.0
2021-10-12 05:00:00	SPY	ETF	434.38	435.12	434.36	434.84	53356.0
2021-10-12 06:00:00	SPY	ETF	434.84	435.38	434.27	435.35	261693.0
2021-10-12 07:00:00	SPY	ETF	435.3	435.54	434.82	434.82	443166.0
2021-10-12 08:00:00	SPY	ETF	435.1001	436.09	431.99	435.27	662699.0
2021-10-12 09:00:00	SPY	ETF	435.29	436.1	433.5	434.11	9783795.0
2021-10-12 10:00:00	SPY	ETF	434.12	435.26	433.5704	434.08	8127230.0
2021-10-12 11:00:00	SPY	ETF	434.1	435.5	434.07	435.33	5409941.0
2021-10-12 12:00:00	SPY	ETF	435.35	436.07	433.98	434.175	5033834.0
2021-10-12 13:00:00	SPY	ETF	434.179	434.8899	433.74	434.2001	4156401.0
2021-10-12 14:00:00	SPY	ETF	434.2	435.57	434.06	434.29	4841815.0
2021-10-12 15:00:00	SPY	ETF	434.3	434.36	432.78	433.63	13157139.0
2021-10-12 16:00:00	SPY	ETF	433.63	433.6892	432.25	432.52	2940094.0
2021-10-12 17:00:00	SPY	ETF	432.58	432.58	432.0	432.36	158505.0
2021-10-12 18:00:00	SPY	ETF	432.34	433.62	432.34	432.5799	128728.0
2021-10-12 19:00:00	SPY	ETF	432.6	432.77	432.3	432.4	49575.0
2021-10-12 04:00:00	QQQ	ETF	357.38	358.47	357.09	358.33	71383.0
2021-10-12 05:00:00	QQQ	ETF	358.45	359.16	358.43	359.01	129157.0
2021-10-12 06:00:00	QQQ	ETF	359.07	359.6	358.73	359.51	132729.0
2021-10-12 07:00:00	QQQ	ETF	359.53	359.8	359.16	359.17	213090.0
2021-10-12 08:00:00	QQQ	ETF	359.16	360.41	355.9	359.51	564015.0
2021-10-12 09:00:00	QQQ	ETF	359.54	360.33	357.37	357.455	6116572.0
2021-10-12 10:00:00	QQQ	ETF	357.45	358.87	356.7704	356.9	6683400.0
2021-10-12 11:00:00	QQQ	ETF	356.93	358.5	356.92	358.5	3714838.0
2021-10-12 12:00:00	QQQ	ETF	358.53	359.18	357.25	357.4	3285370.0
2021-10-12 13:00:00	QQQ	ETF	357.39	357.925	356.84	357.4	2633434.0
2021-10-12 14:00:00	QQQ	ETF	357.34	358.87	357.2109	357.67	3163323.0
2021-10-12 15:00:00	QQQ	ETF	357.665	357.9299	356.48	357.15	5939701.0
2021-10-12 16:00:00	QQQ	ETF	357.15	357.882	355.59	355.91	2152710.0
2021-10-12 17:00:00	QQQ	ETF	355.92	357.16	355.69	355.84	145991.0
2021-10-12 18:00:00	QQQ	ETF	355.76	356.16	355.76	356.08	40905.0
2021-10-12 19:00:00	QQQ	ETF	356.13	356.34	356.0	356.03	64249.0
2021-10-12 04:00:00	IWM	ETF	219.31	220.01	218.94	219.92	39470.0
2021-10-12 05:00:00	IWM	ETF	220.2	220.49	220.2	220.32	34635.0
2021-10-12 06:00:00	IWM	ETF	220.5	220.5	219.79	220.5	46117.0
2021-10-12 07:00:00	IWM	ETF	220.41	220.5	220.09	220.14	149711.0
2021-10-12 08:00:00	IWM	ETF	219.9296	220.88	219.9196	220.52	163319.0
2021-10-12 09:00:00	IWM	ETF	220.56	222.145	220.36	221.33	2833928.0
2021-10-12 10:00:00	IWM	ETF	221.34	222.12	220.57	221.44	3030684.0
2021-10-12 11:00:00	IWM	ETF	221.46	222.085	221.12	222.05	1639445.0
2021-10-12 12:00:00	IWM	ETF	222.06	222.4599	221.491	221.67	1059719.0
2021-10-12 13:00:00	IWM	ETF	221.67	222.09	221.41	221.71	984847.0
2021-10-12 14:00:00	IWM	ETF	221.67	222.47	221.64	222.05	1231193.0
2021-10-12 15:00:00	IWM	ETF	222.05	222.105	221.14	221.54	2710820.0
2021-10-12 16:00:00	IWM	ETF	221.52	221.63	220.98	221.17	875209.0
2021-10-12 17:00:00	IWM	ETF	221.01	221.23	220.93	221.17	10622.0
2021-10-12 18:00:00	IWM	ETF	221.14	221.52	221.06	221.17	18927.0
2021-10-12 19:00:00	IWM	ETF	221.31	221.38	220.96	220.96	31629.0
2021-10-12 04:00:00	DIA	ETF	343.69	344.69	343.54	344.58	3624.0
2021-10-12 05:00:00	DIA	ETF	344.77	345.16	344.77	344.95	2560.0

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

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