PREVIEW / etf_1hour / 2010-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-12.parquet
  size:    153 KB
  rows:    4,850

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
2010-04-12 04:00:00	SPY	ETF	119.82	119.95	119.82	119.95	5268.0
2010-04-12 05:00:00	SPY	ETF	119.85	119.85	119.85	119.85	500.0
2010-04-12 06:00:00	SPY	ETF	119.81	119.83	119.75	119.77	9900.0
2010-04-12 07:00:00	SPY	ETF	119.8	119.86	119.6	119.74	331557.0
2010-04-12 08:00:00	SPY	ETF	119.72	119.79	119.58	119.64	905603.0
2010-04-12 09:00:00	SPY	ETF	119.64	119.96	119.59	119.59	16492039.0
2010-04-12 10:00:00	SPY	ETF	119.59	119.9	119.56	119.87	14652473.0
2010-04-12 11:00:00	SPY	ETF	119.87	119.92	119.66	119.82	9951630.0
2010-04-12 12:00:00	SPY	ETF	119.82	119.91	119.76	119.9	11219304.0
2010-04-12 13:00:00	SPY	ETF	119.89	120.05	119.8	119.81	10476251.0
2010-04-12 14:00:00	SPY	ETF	119.8	119.98	119.77	119.929	10943964.0
2010-04-12 15:00:00	SPY	ETF	119.928	119.97	119.6	119.76	24616490.0
2010-04-12 16:00:00	SPY	ETF	119.76	119.93	119.63	119.71	6767954.0
2010-04-12 17:00:00	SPY	ETF	119.71	119.73	119.64	119.68	205410.0
2010-04-12 18:00:00	SPY	ETF	119.7	119.7	119.66	119.66	8466.0
2010-04-12 19:00:00	SPY	ETF	119.66	119.67	119.6	119.63	69519.0
2010-04-12 06:00:00	QQQ	ETF	49.12	49.12	49.1	49.1	1360.0
2010-04-12 07:00:00	QQQ	ETF	49.11	49.11	49.02	49.07	42600.0
2010-04-12 08:00:00	QQQ	ETF	49.07	49.08	49.02	49.04	239234.0
2010-04-12 09:00:00	QQQ	ETF	49.04	49.32	48.94	48.97	8305630.0
2010-04-12 10:00:00	QQQ	ETF	48.97	49.12	48.95	49.12	9209901.0
2010-04-12 11:00:00	QQQ	ETF	49.11	49.14	49.02	49.09	4250039.0
2010-04-12 12:00:00	QQQ	ETF	49.09	49.1435	49.05	49.11	3062978.0
2010-04-12 13:00:00	QQQ	ETF	49.11	49.2	49.11	49.1299	3413270.0
2010-04-12 14:00:00	QQQ	ETF	49.13	49.19	49.11	49.18	3748827.0
2010-04-12 15:00:00	QQQ	ETF	49.1792	49.19	49.03	49.07	7300651.0
2010-04-12 16:00:00	QQQ	ETF	49.06	49.1923	49.0	49.04	1267966.0
2010-04-12 17:00:00	QQQ	ETF	49.03	49.04	49.01	49.02	22621.0
2010-04-12 18:00:00	QQQ	ETF	49.03	49.05	49.02	49.04	28173.0
2010-04-12 19:00:00	QQQ	ETF	49.04	49.04	49.0	49.02	31317.0
2010-04-12 06:00:00	IWM	ETF	70.42	70.42	70.42	70.42	8100.0
2010-04-12 07:00:00	IWM	ETF	70.39	70.41	70.3	70.34	107894.0
2010-04-12 08:00:00	IWM	ETF	70.34	70.38	70.22	70.26	221104.0
2010-04-12 09:00:00	IWM	ETF	70.26	70.46	70.15	70.15	5724041.0
2010-04-12 10:00:00	IWM	ETF	70.15	70.43	70.12	70.37	5295583.0
2010-04-12 11:00:00	IWM	ETF	70.36	70.52	70.3	70.46	4285415.0
2010-04-12 12:00:00	IWM	ETF	70.46	70.57	70.39	70.565	3674179.0
2010-04-12 13:00:00	IWM	ETF	70.56	70.68	70.51	70.52	4829966.0
2010-04-12 14:00:00	IWM	ETF	70.53	70.56	70.42	70.53	3963500.0
2010-04-12 15:00:00	IWM	ETF	70.53	70.61	70.32	70.53	10561787.0
2010-04-12 16:00:00	IWM	ETF	70.53	70.55	70.2871	70.5	8657363.0
2010-04-12 17:00:00	IWM	ETF	70.41	70.41	70.37	70.41	4700.0
2010-04-12 18:00:00	IWM	ETF	70.47	70.47	70.37	70.37	4700.0
2010-04-12 19:00:00	IWM	ETF	70.4	70.4	70.4	70.4	500.0
2010-04-12 07:00:00	DIA	ETF	110.19	110.19	110.19	110.19	250.0
2010-04-12 08:00:00	DIA	ETF	110.17	110.21	110.03	110.09	11746.0
2010-04-12 09:00:00	DIA	ETF	110.12	110.3	110.03	110.05	673577.0
2010-04-12 10:00:00	DIA	ETF	110.03	110.29	110.01	110.28	628031.0
2010-04-12 11:00:00	DIA	ETF	110.27	110.29	110.08	110.25	364623.0
2010-04-12 12:00:00	DIA	ETF	110.25	110.29	110.19	110.2701	321347.0

> showing 50 of 4,850 rows — these rows as CSV

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