PREVIEW / etf_1hour / 2008-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-18.parquet
  size:    122 KB
  rows:    3,932

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-09-18 04:00:00	SPY	ETF	117.69	118.3	117.69	117.91	11100.0
2008-09-18 05:00:00	SPY	ETF	117.81	118.15	117.81	117.91	15400.0
2008-09-18 06:00:00	SPY	ETF	117.98	118.5	117.7	118.5	360880.0
2008-09-18 07:00:00	SPY	ETF	118.45	118.56	117.82	117.96	2546740.0
2008-09-18 08:00:00	SPY	ETF	117.96	118.31	116.99	117.44	12865932.0
2008-09-18 09:00:00	SPY	ETF	117.44	118.68	117.07	118.54	65500825.0
2008-09-18 10:00:00	SPY	ETF	118.5	119.0	116.9	117.02	61394828.0
2008-09-18 11:00:00	SPY	ETF	117.01	117.23	115.42	116.3301	75750015.0
2008-09-18 12:00:00	SPY	ETF	116.338	117.6	113.81	113.85	99259247.0
2008-09-18 13:00:00	SPY	ETF	113.86	117.99	113.8	117.35	126985493.0
2008-09-18 14:00:00	SPY	ETF	117.34	117.56	115.89	117.35	82714679.0
2008-09-18 15:00:00	SPY	ETF	117.35	121.79	117.19	120.59	180669584.0
2008-09-18 16:00:00	SPY	ETF	120.55	121.12	116.1752	120.39	24306883.0
2008-09-18 17:00:00	SPY	ETF	120.39	120.85	116.18	120.79	13866632.0
2008-09-18 18:00:00	SPY	ETF	120.76	122.07	120.54	121.87	1290934.0
2008-09-18 19:00:00	SPY	ETF	121.85	123.19	121.57	122.9	17555898.0
2008-09-18 04:00:00	QQQ	ETF	40.65	40.81	40.62	40.79	27800.0
2008-09-18 05:00:00	QQQ	ETF	40.77	40.81	40.77	40.81	600.0
2008-09-18 06:00:00	QQQ	ETF	40.68	40.96	40.64	40.95	362400.0
2008-09-18 07:00:00	QQQ	ETF	40.92	40.93	40.77	40.87	120023.0
2008-09-18 08:00:00	QQQ	ETF	40.87	40.93	40.63	40.79	3883646.0
2008-09-18 09:00:00	QQQ	ETF	40.78	41.25	40.46	40.89	53147825.0
2008-09-18 10:00:00	QQQ	ETF	40.89	41.21	40.26	40.27	43877216.0
2008-09-18 11:00:00	QQQ	ETF	40.27	40.42	39.79	40.1	43403535.0
2008-09-18 12:00:00	QQQ	ETF	40.09	40.21	39.51	39.57	43507431.0
2008-09-18 13:00:00	QQQ	ETF	39.57	40.45	39.5	40.17	63809164.0
2008-09-18 14:00:00	QQQ	ETF	40.17	40.3	39.85	40.12	38900674.0
2008-09-18 15:00:00	QQQ	ETF	40.12	41.97	40.08	41.53	98116625.0
2008-09-18 16:00:00	QQQ	ETF	41.54	41.8732	40.1692	41.8	18519864.0
2008-09-18 17:00:00	QQQ	ETF	41.8	41.83	41.2732	41.83	294749.0
2008-09-18 18:00:00	QQQ	ETF	41.78	42.16	41.77	42.15	639967.0
2008-09-18 19:00:00	QQQ	ETF	42.12	42.66	42.08	42.62	701866.0
2008-09-18 07:00:00	IWM	ETF	69.12	69.3	68.85	68.98	250183.0
2008-09-18 08:00:00	IWM	ETF	68.98	69.25	68.7	68.95	1876582.0
2008-09-18 09:00:00	IWM	ETF	68.94	69.46	68.33	69.23	28024497.0
2008-09-18 10:00:00	IWM	ETF	69.23	69.59	68.47	68.52	26239526.0
2008-09-18 11:00:00	IWM	ETF	68.54	68.67	67.65	68.2	32903220.0
2008-09-18 12:00:00	IWM	ETF	68.2	68.35	67.16	67.19	31650148.0
2008-09-18 13:00:00	IWM	ETF	67.19	69.68	67.19	69.32	46276989.0
2008-09-18 14:00:00	IWM	ETF	69.32	69.46	68.32	69.26	34382204.0
2008-09-18 15:00:00	IWM	ETF	69.25	72.15	69.16	71.84	80254726.0
2008-09-18 16:00:00	IWM	ETF	71.88	71.97	67.6	71.2	11734149.0
2008-09-18 17:00:00	IWM	ETF	71.29	71.81	67.6	71.53	28019794.0
2008-09-18 18:00:00	IWM	ETF	71.53	72.3	68.48	72.05	219291.0
2008-09-18 19:00:00	IWM	ETF	72.08	72.48	72.05	72.48	12565.0
2008-09-18 06:00:00	DIA	ETF	107.69	107.92	107.69	107.92	2400.0
2008-09-18 07:00:00	DIA	ETF	108.02	108.13	107.7	107.85	27056.0
2008-09-18 08:00:00	DIA	ETF	107.8	107.85	107.08	107.33	217004.0
2008-09-18 09:00:00	DIA	ETF	107.3	108.15	107.03	108.01	4844288.0
2008-09-18 10:00:00	DIA	ETF	108.0	108.46	106.85	106.92	6087677.0

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

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