PREVIEW / etf_1hour / 2008-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-28.parquet
  size:    106 KB
  rows:    3,434

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
2008-08-28 04:00:00	SPY	ETF	128.0	128.0	128.0	128.0	300.0
2008-08-28 06:00:00	SPY	ETF	128.51	128.51	128.5	128.5	6000.0
2008-08-28 07:00:00	SPY	ETF	128.51	128.64	128.43	128.5	318852.0
2008-08-28 08:00:00	SPY	ETF	128.5	129.5	128.43	129.42	5377085.0
2008-08-28 09:00:00	SPY	ETF	129.42	129.5	129.11	129.34	22406567.0
2008-08-28 10:00:00	SPY	ETF	129.34	129.68	129.15	129.56	26879649.0
2008-08-28 11:00:00	SPY	ETF	129.56	129.99	129.21	129.91	24595718.0
2008-08-28 12:00:00	SPY	ETF	129.91	130.0	129.66	129.84	16346496.0
2008-08-28 13:00:00	SPY	ETF	129.84	130.12	129.69	129.95	12979206.0
2008-08-28 14:00:00	SPY	ETF	129.95	130.22	129.68	130.07	16339286.0
2008-08-28 15:00:00	SPY	ETF	130.06	130.34	129.91	130.3	27252909.0
2008-08-28 16:00:00	SPY	ETF	130.28	130.41	130.02	130.1	9149652.0
2008-08-28 17:00:00	SPY	ETF	130.12	130.19	130.06	130.1	1205289.0
2008-08-28 18:00:00	SPY	ETF	130.11	130.12	130.07	130.07	47951.0
2008-08-28 19:00:00	SPY	ETF	130.06	130.238	129.98	129.98	123983.0
2008-08-28 04:00:00	QQQ	ETF	46.53	46.53	46.52	46.52	500.0
2008-08-28 06:00:00	QQQ	ETF	46.71	46.71	46.63	46.63	1300.0
2008-08-28 07:00:00	QQQ	ETF	46.65	46.71	46.61	46.66	78323.0
2008-08-28 08:00:00	QQQ	ETF	46.67	47.06	46.65	47.06	3144720.0
2008-08-28 09:00:00	QQQ	ETF	47.06	47.0701	46.83	47.04	15537241.0
2008-08-28 10:00:00	QQQ	ETF	47.04	47.22	46.95	47.15	16265589.0
2008-08-28 11:00:00	QQQ	ETF	47.15	47.28	47.02	47.2295	14135040.0
2008-08-28 12:00:00	QQQ	ETF	47.225	47.23	47.04	47.13	8984278.0
2008-08-28 13:00:00	QQQ	ETF	47.14	47.24	47.08	47.16	6958543.0
2008-08-28 14:00:00	QQQ	ETF	47.16	47.225	46.98	47.17	11464121.0
2008-08-28 15:00:00	QQQ	ETF	47.16	47.21	47.03	47.1	17468798.0
2008-08-28 16:00:00	QQQ	ETF	47.09	47.152	46.77	46.89	11285355.0
2008-08-28 17:00:00	QQQ	ETF	46.84	47.11	46.83	46.84	376417.0
2008-08-28 18:00:00	QQQ	ETF	46.87	46.89	46.84	46.86	55861.0
2008-08-28 19:00:00	QQQ	ETF	46.86	46.86	46.84	46.86	49754.0
2008-08-28 07:00:00	IWM	ETF	72.93	73.06	72.93	72.97	45742.0
2008-08-28 08:00:00	IWM	ETF	72.99	73.58	72.92	73.53	1071387.0
2008-08-28 09:00:00	IWM	ETF	73.53	73.63	73.03	73.43	6242828.0
2008-08-28 10:00:00	IWM	ETF	73.44	73.9	73.27	73.77	12983708.0
2008-08-28 11:00:00	IWM	ETF	73.76	74.0	73.54	73.93	7206488.0
2008-08-28 12:00:00	IWM	ETF	73.92	74.05	73.76	73.88	6314531.0
2008-08-28 13:00:00	IWM	ETF	73.88	74.36	73.83	74.28	8922842.0
2008-08-28 14:00:00	IWM	ETF	74.28	74.65	74.07	74.54	12616701.0
2008-08-28 15:00:00	IWM	ETF	74.54	74.65	73.6	74.58	10993552.0
2008-08-28 16:00:00	IWM	ETF	74.57	74.66	73.18	74.36	3471882.0
2008-08-28 17:00:00	IWM	ETF	74.33	74.41	74.33	74.35	151449.0
2008-08-28 18:00:00	IWM	ETF	74.39	74.39	74.39	74.39	2067.0
2008-08-28 19:00:00	IWM	ETF	74.33	74.33	74.33	74.33	1100.0
2008-08-28 07:00:00	DIA	ETF	114.99	115.07	114.96	114.96	5500.0
2008-08-28 08:00:00	DIA	ETF	115.04	115.83	114.98	115.76	127309.0
2008-08-28 09:00:00	DIA	ETF	115.82	116.06	115.66	116.03	2073703.0
2008-08-28 10:00:00	DIA	ETF	116.03	116.63	115.91	116.49	3701837.0
2008-08-28 11:00:00	DIA	ETF	116.49	117.04	116.31	117.01	3570535.0
2008-08-28 12:00:00	DIA	ETF	117.02	117.05	116.69	116.8	1714991.0
2008-08-28 13:00:00	DIA	ETF	116.79	117.07	116.67	116.98	1108687.0

> showing 50 of 3,434 rows — these rows as CSV

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