PREVIEW / etf_1hour / 2008-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-13.parquet
  size:    106 KB
  rows:    3,389

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-06-13 04:00:00	SPY	ETF	134.21	134.21	134.21	134.21	500.0
2008-06-13 05:00:00	SPY	ETF	134.33	134.33	134.33	134.33	100.0
2008-06-13 06:00:00	SPY	ETF	134.55	134.76	134.46	134.7	22500.0
2008-06-13 07:00:00	SPY	ETF	134.75	134.76	134.37	134.66	575409.0
2008-06-13 08:00:00	SPY	ETF	134.46	135.47	134.1	135.21	15265638.0
2008-06-13 09:00:00	SPY	ETF	135.22	135.39	134.61	135.25	37794409.0
2008-06-13 10:00:00	SPY	ETF	135.25	136.35	135.15	135.77	52290077.0
2008-06-13 11:00:00	SPY	ETF	135.77	136.13	135.7	135.78	21853201.0
2008-06-13 12:00:00	SPY	ETF	135.77	135.93	135.35	135.41	19709520.0
2008-06-13 13:00:00	SPY	ETF	135.41	135.51	134.87	135.12	26313887.0
2008-06-13 14:00:00	SPY	ETF	135.13	135.725	134.9	135.69	24964489.0
2008-06-13 15:00:00	SPY	ETF	135.7	136.42	135.33	136.4	35577041.0
2008-06-13 16:00:00	SPY	ETF	136.4101	136.52	135.1	136.05	5834991.0
2008-06-13 17:00:00	SPY	ETF	136.05	136.09	135.92	135.99	113333.0
2008-06-13 18:00:00	SPY	ETF	135.98	136.14	135.98	136.1	31738.0
2008-06-13 19:00:00	SPY	ETF	136.05	136.09	136.02	136.02	7939.0
2008-06-13 05:00:00	QQQ	ETF	47.27	47.27	47.27	47.27	300.0
2008-06-13 06:00:00	QQQ	ETF	47.33	47.42	47.33	47.42	12000.0
2008-06-13 07:00:00	QQQ	ETF	47.43	47.44	47.3	47.4	151848.0
2008-06-13 08:00:00	QQQ	ETF	47.4	47.87	47.32	47.8	7693258.0
2008-06-13 09:00:00	QQQ	ETF	47.8	47.86	47.46	47.841	26285391.0
2008-06-13 10:00:00	QQQ	ETF	47.84	48.47	47.81	48.2	42941308.0
2008-06-13 11:00:00	QQQ	ETF	48.2	48.34	48.19	48.24	11659841.0
2008-06-13 12:00:00	QQQ	ETF	48.24	48.3001	48.01	48.11	11170214.0
2008-06-13 13:00:00	QQQ	ETF	48.11	48.14	47.8	47.9	16012524.0
2008-06-13 14:00:00	QQQ	ETF	47.9	48.17	47.79	48.15	15784287.0
2008-06-13 15:00:00	QQQ	ETF	48.151	48.39	47.91	48.38	21479163.0
2008-06-13 16:00:00	QQQ	ETF	48.39	48.39	48.0131	48.36	7410607.0
2008-06-13 17:00:00	QQQ	ETF	48.36	48.38	48.34	48.35	79016.0
2008-06-13 18:00:00	QQQ	ETF	48.34	48.39	48.34	48.39	6950.0
2008-06-13 19:00:00	QQQ	ETF	48.38	48.38	48.33	48.33	4651.0
2008-06-13 05:00:00	IWM	ETF	71.94	71.94	71.89	71.89	200.0
2008-06-13 07:00:00	IWM	ETF	72.06	72.09	71.9	72.09	313748.0
2008-06-13 08:00:00	IWM	ETF	72.27	72.7	71.8	72.53	4437776.0
2008-06-13 09:00:00	IWM	ETF	72.59	72.89	72.31	72.83	12769705.0
2008-06-13 10:00:00	IWM	ETF	72.84	73.12	72.64	72.77	13464126.0
2008-06-13 11:00:00	IWM	ETF	72.78	73.0	72.78	72.84	3961531.0
2008-06-13 12:00:00	IWM	ETF	72.83	72.91	72.66	72.74	4465470.0
2008-06-13 13:00:00	IWM	ETF	72.73	72.86	72.34	72.5	8709306.0
2008-06-13 14:00:00	IWM	ETF	72.51	72.82	72.41	72.79	8540490.0
2008-06-13 15:00:00	IWM	ETF	72.8	73.31	72.64	73.29	13602228.0
2008-06-13 16:00:00	IWM	ETF	73.29	73.38	72.77	73.29	5007801.0
2008-06-13 17:00:00	IWM	ETF	73.25	73.25	73.2	73.2	4750.0
2008-06-13 19:00:00	IWM	ETF	73.1	73.32	73.06	73.32	1000.0
2008-06-13 07:00:00	DIA	ETF	121.72	121.8	121.72	121.78	1154.0
2008-06-13 08:00:00	DIA	ETF	121.8	122.4	121.59	122.23	144070.0
2008-06-13 09:00:00	DIA	ETF	122.3	122.42	121.77	122.36	2087897.0
2008-06-13 10:00:00	DIA	ETF	122.34	123.23	122.28	122.64	4164695.0
2008-06-13 11:00:00	DIA	ETF	122.65	123.0	122.6	122.66	1359862.0
2008-06-13 12:00:00	DIA	ETF	122.66	122.79	122.3	122.34	1144834.0

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

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