PREVIEW / etf_1hour / 2010-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-29.parquet
  size:    152 KB
  rows:    4,804

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-03-29 04:00:00	SPY	ETF	117.5	117.52	117.43	117.43	4150.0
2010-03-29 05:00:00	SPY	ETF	117.43	117.48	117.4	117.4	2500.0
2010-03-29 06:00:00	SPY	ETF	117.42	117.45	117.35	117.36	30100.0
2010-03-29 07:00:00	SPY	ETF	117.37	117.45	117.24	117.27	135549.0
2010-03-29 08:00:00	SPY	ETF	117.25	117.7	117.15	117.18	1479235.0
2010-03-29 09:00:00	SPY	ETF	117.17	117.43	117.06	117.12	23891607.0
2010-03-29 10:00:00	SPY	ETF	117.11	117.32	116.97	117.29	22733001.0
2010-03-29 11:00:00	SPY	ETF	117.3	117.53	117.28	117.368	11938902.0
2010-03-29 12:00:00	SPY	ETF	117.365	117.39	116.6886	117.17	11324597.0
2010-03-29 13:00:00	SPY	ETF	117.18	117.35	117.11	117.23	11625617.0
2010-03-29 14:00:00	SPY	ETF	117.2399	117.34	117.06	117.3338	16907010.0
2010-03-29 15:00:00	SPY	ETF	117.34	117.43	117.26	117.34	20206390.0
2010-03-29 16:00:00	SPY	ETF	117.35	117.52	116.6886	117.32	12619596.0
2010-03-29 17:00:00	SPY	ETF	117.32	117.44	117.32	117.43	221299.0
2010-03-29 18:00:00	SPY	ETF	117.42	117.43	117.35	117.41	167130.0
2010-03-29 19:00:00	SPY	ETF	117.39	117.42	117.35	117.37	37624.0
2010-03-29 04:00:00	QQQ	ETF	48.29	48.29	48.29	48.29	1000.0
2010-03-29 06:00:00	QQQ	ETF	48.28	48.31	48.28	48.29	11500.0
2010-03-29 07:00:00	QQQ	ETF	48.27	48.3	48.25	48.25	31000.0
2010-03-29 08:00:00	QQQ	ETF	48.23	48.27	48.2	48.23	244033.0
2010-03-29 09:00:00	QQQ	ETF	48.22	48.4	48.17	48.26	9090817.0
2010-03-29 10:00:00	QQQ	ETF	48.27	48.3625	48.22	48.29	10535059.0
2010-03-29 11:00:00	QQQ	ETF	48.29	48.4	48.27	48.37	6081282.0
2010-03-29 12:00:00	QQQ	ETF	48.3601	48.38	48.2	48.2119	3500192.0
2010-03-29 13:00:00	QQQ	ETF	48.21	48.28	48.13	48.18	4865128.0
2010-03-29 14:00:00	QQQ	ETF	48.18	48.22	48.1	48.2	6856715.0
2010-03-29 15:00:00	QQQ	ETF	48.2	48.24	48.15	48.2301	6616878.0
2010-03-29 16:00:00	QQQ	ETF	48.23	48.27	48.0061	48.25	4263627.0
2010-03-29 17:00:00	QQQ	ETF	48.24	48.32	48.24	48.31	115831.0
2010-03-29 18:00:00	QQQ	ETF	48.32	48.35	48.32	48.33	118727.0
2010-03-29 19:00:00	QQQ	ETF	48.34	48.35	48.33	48.34	65850.0
2010-03-29 07:00:00	IWM	ETF	68.32	68.33	68.24	68.24	30600.0
2010-03-29 08:00:00	IWM	ETF	68.05	68.43	68.05	68.16	435377.0
2010-03-29 09:00:00	IWM	ETF	68.15	68.34	68.02	68.04	5049513.0
2010-03-29 10:00:00	IWM	ETF	68.04	68.32	67.92	68.3	6637709.0
2010-03-29 11:00:00	IWM	ETF	68.3	68.4	68.13	68.24	4514156.0
2010-03-29 12:00:00	IWM	ETF	68.2499	68.26	68.0	68.04	2067340.0
2010-03-29 13:00:00	IWM	ETF	68.04	68.22	67.99	68.1	3213511.0
2010-03-29 14:00:00	IWM	ETF	68.1	68.13	67.81	68.0	5650235.0
2010-03-29 15:00:00	IWM	ETF	68.01	68.22	68.01	68.17	6704288.0
2010-03-29 16:00:00	IWM	ETF	68.16	68.3	68.0501	68.17	1250732.0
2010-03-29 17:00:00	IWM	ETF	68.22	68.24	68.22	68.24	2900.0
2010-03-29 18:00:00	IWM	ETF	68.24	68.28	68.22	68.24	700.0
2010-03-29 19:00:00	IWM	ETF	68.22	68.28	68.22	68.28	2400.0
2010-03-29 04:00:00	DIA	ETF	108.65	108.72	108.65	108.72	1500.0
2010-03-29 07:00:00	DIA	ETF	108.95	108.98	108.9	108.9	1400.0
2010-03-29 08:00:00	DIA	ETF	108.88	108.92	108.8	108.8	9046.0
2010-03-29 09:00:00	DIA	ETF	108.8	109.08	108.71	108.8	804096.0
2010-03-29 10:00:00	DIA	ETF	108.81	108.96	108.67	108.94	1134449.0
2010-03-29 11:00:00	DIA	ETF	108.94	109.16	108.93	109.0001	525638.0

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

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