PREVIEW / etf_1hour / 2009-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-26.parquet
  size:    149 KB
  rows:    4,546

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
2009-10-26 04:00:00	SPY	ETF	108.43	108.54	108.36	108.36	2292.0
2009-10-26 05:00:00	SPY	ETF	108.31	108.61	108.31	108.61	4925.0
2009-10-26 06:00:00	SPY	ETF	108.69	108.7	108.5	108.5	17695.0
2009-10-26 07:00:00	SPY	ETF	108.42	108.44	108.18	108.2	299447.0
2009-10-26 08:00:00	SPY	ETF	108.23	108.69	108.2	108.37	1076113.0
2009-10-26 09:00:00	SPY	ETF	108.36	109.16	108.1	109.062	23918149.0
2009-10-26 10:00:00	SPY	ETF	109.04	109.31	108.89	109.02	26101472.0
2009-10-26 11:00:00	SPY	ETF	109.02	109.2	106.96	107.0	65238511.0
2009-10-26 12:00:00	SPY	ETF	107.0	107.38	106.69	107.3199	35244932.0
2009-10-26 13:00:00	SPY	ETF	107.31	107.371	106.86	107.12	17259523.0
2009-10-26 14:00:00	SPY	ETF	107.12	108.0812	106.64	106.9	25488743.0
2009-10-26 15:00:00	SPY	ETF	106.9	107.22	106.61	106.84	34047883.0
2009-10-26 16:00:00	SPY	ETF	106.85	109.0937	106.8163	107.03	8436975.0
2009-10-26 17:00:00	SPY	ETF	107.03	107.07	106.78	106.81	192060.0
2009-10-26 18:00:00	SPY	ETF	106.85	106.97	106.82	106.9	295984.0
2009-10-26 19:00:00	SPY	ETF	106.9	106.95	106.86	106.95	69735.0
2009-10-26 04:00:00	QQQ	ETF	43.25	43.25	43.25	43.25	100.0
2009-10-26 05:00:00	QQQ	ETF	43.31	43.31	43.31	43.31	5000.0
2009-10-26 06:00:00	QQQ	ETF	43.36	43.38	43.31	43.33	6500.0
2009-10-26 07:00:00	QQQ	ETF	43.28	43.28	43.18	43.2	10340.0
2009-10-26 08:00:00	QQQ	ETF	43.17	43.24	43.16	43.22	233298.0
2009-10-26 09:00:00	QQQ	ETF	43.22	43.7	43.13	43.65	13816985.0
2009-10-26 10:00:00	QQQ	ETF	43.66	43.76	43.6	43.68	10961599.0
2009-10-26 11:00:00	QQQ	ETF	43.695	43.74	42.95	42.95	27678408.0
2009-10-26 12:00:00	QQQ	ETF	42.96	43.2	42.79	43.03	16319270.0
2009-10-26 13:00:00	QQQ	ETF	43.04	43.08	42.86	43.005	6983809.0
2009-10-26 14:00:00	QQQ	ETF	43.0	43.05	42.84	42.95	10915348.0
2009-10-26 15:00:00	QQQ	ETF	42.94	43.11	42.87	42.98	15010848.0
2009-10-26 16:00:00	QQQ	ETF	42.99	43.3968	42.97	43.0	2531814.0
2009-10-26 17:00:00	QQQ	ETF	43.04	43.05	42.82	42.86	345205.0
2009-10-26 18:00:00	QQQ	ETF	42.88	42.97	42.87	42.89	343167.0
2009-10-26 19:00:00	QQQ	ETF	42.89	42.91	42.87	42.91	71265.0
2009-10-26 06:00:00	IWM	ETF	60.54	60.54	60.54	60.54	5000.0
2009-10-26 07:00:00	IWM	ETF	60.44	60.44	60.3	60.33	100162.0
2009-10-26 08:00:00	IWM	ETF	60.3	60.39	60.24	60.35	928715.0
2009-10-26 09:00:00	IWM	ETF	60.35	61.08	60.14	60.94	8629415.0
2009-10-26 10:00:00	IWM	ETF	60.95	61.17	60.75	60.88	5807090.0
2009-10-26 11:00:00	IWM	ETF	60.87	61.005	59.5123	59.54	15613768.0
2009-10-26 12:00:00	IWM	ETF	59.54	59.86	59.22	59.76	8931198.0
2009-10-26 13:00:00	IWM	ETF	59.75	59.81	59.41	59.59	5654803.0
2009-10-26 14:00:00	IWM	ETF	59.59	59.72	59.32	59.4725	8810562.0
2009-10-26 15:00:00	IWM	ETF	59.46	59.66	59.22	59.48	8855610.0
2009-10-26 16:00:00	IWM	ETF	59.48	61.0	59.48	59.59	5249033.0
2009-10-26 17:00:00	IWM	ETF	59.62	59.65	59.52	59.53	19173.0
2009-10-26 18:00:00	IWM	ETF	59.54	59.57	59.43	59.43	11187.0
2009-10-26 19:00:00	IWM	ETF	59.46	59.55	59.46	59.5	2200.0
2009-10-26 08:00:00	DIA	ETF	100.1	101.0	99.9	100.0	15600.0
2009-10-26 09:00:00	DIA	ETF	100.05	100.6499	99.86	100.51	1753919.0
2009-10-26 10:00:00	DIA	ETF	100.53	100.77	100.5	100.61	1441949.0
2009-10-26 11:00:00	DIA	ETF	100.61	100.75	98.77	98.8	4816172.0

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

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