PREVIEW / etf_1hour / 2008-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-04.parquet
  size:    100 KB
  rows:    3,326

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-01-04 06:00:00	SPY	ETF	145.31	145.33	145.22	145.28	35000.0
2008-01-04 07:00:00	SPY	ETF	145.28	145.28	145.0	145.19	553600.0
2008-01-04 08:00:00	SPY	ETF	145.2	145.34	143.28	143.38	15785100.0
2008-01-04 09:00:00	SPY	ETF	143.4	143.44	142.66	142.96	27541342.0
2008-01-04 10:00:00	SPY	ETF	142.9584	143.17	141.84	141.93	29092225.0
2008-01-04 11:00:00	SPY	ETF	141.92	143.0	141.72	142.31	34468088.0
2008-01-04 12:00:00	SPY	ETF	142.31	142.7	141.9	142.13	20449728.0
2008-01-04 13:00:00	SPY	ETF	142.12	142.21	141.5	142.01	18422053.0
2008-01-04 14:00:00	SPY	ETF	142.01	142.01	140.99	141.48	24414915.0
2008-01-04 15:00:00	SPY	ETF	141.48	142.0	140.92	140.93	43570468.0
2008-01-04 16:00:00	SPY	ETF	140.92	144.51	140.9099	141.38	11393200.0
2008-01-04 17:00:00	SPY	ETF	141.4	141.45	141.18	141.25	101800.0
2008-01-04 18:00:00	SPY	ETF	141.18	141.33	141.18	141.3	11800.0
2008-01-04 19:00:00	SPY	ETF	141.25	141.3	141.23	141.3	9400.0
2008-01-04 06:00:00	QQQ	ETF	50.65	50.65	50.64	50.64	10000.0
2008-01-04 07:00:00	QQQ	ETF	50.68	50.68	50.53	50.57	428830.0
2008-01-04 08:00:00	QQQ	ETF	50.59	50.61	49.8	49.81	7660024.0
2008-01-04 09:00:00	QQQ	ETF	49.81	49.83	49.53	49.61	20955599.0
2008-01-04 10:00:00	QQQ	ETF	49.61	49.72	48.87	48.93	35732824.0
2008-01-04 11:00:00	QQQ	ETF	48.92	49.24	48.86	49.1499	24261660.0
2008-01-04 12:00:00	QQQ	ETF	49.14	49.35	49.01	49.08	16988206.0
2008-01-04 13:00:00	QQQ	ETF	49.07	49.12	48.76	49.02	19740750.0
2008-01-04 14:00:00	QQQ	ETF	49.02	49.028	48.31	48.5799	31164902.0
2008-01-04 15:00:00	QQQ	ETF	48.57	48.69	48.25	48.28	46142630.0
2008-01-04 16:00:00	QQQ	ETF	48.28	49.6	48.21	48.49	9388604.0
2008-01-04 17:00:00	QQQ	ETF	48.47	48.55	48.47	48.48	103860.0
2008-01-04 18:00:00	QQQ	ETF	48.48	48.53	48.48	48.5	56420.0
2008-01-04 19:00:00	QQQ	ETF	48.5	48.5	48.4	48.4	25265.0
2008-01-04 05:00:00	IWM	ETF	74.6	74.6	74.6	74.6	200.0
2008-01-04 07:00:00	IWM	ETF	74.44	74.5	74.38	74.4	146700.0
2008-01-04 08:00:00	IWM	ETF	74.39	74.53	73.03	73.13	3752400.0
2008-01-04 09:00:00	IWM	ETF	73.14	73.33	72.56	72.99	15455605.0
2008-01-04 10:00:00	IWM	ETF	73.0	73.17	72.17	72.2	13437050.0
2008-01-04 11:00:00	IWM	ETF	72.19	72.63	71.96	72.51	16518093.0
2008-01-04 12:00:00	IWM	ETF	72.52	72.82	72.29	72.46	7674100.0
2008-01-04 13:00:00	IWM	ETF	72.46	72.52	72.0	72.4	9996311.0
2008-01-04 14:00:00	IWM	ETF	72.4	72.42	71.61	71.96	16320347.0
2008-01-04 15:00:00	IWM	ETF	71.97	72.46	71.71	71.87	26862725.0
2008-01-04 16:00:00	IWM	ETF	71.87	74.15	71.79	72.05	10346400.0
2008-01-04 17:00:00	IWM	ETF	72.14	72.14	71.93	72.0	3011100.0
2008-01-04 18:00:00	IWM	ETF	72.0	72.08	72.0	72.08	4000.0
2008-01-04 19:00:00	IWM	ETF	72.1	72.12	72.1	72.12	4500.0
2008-01-04 07:00:00	DIA	ETF	131.0	131.03	130.88	131.03	5300.0
2008-01-04 08:00:00	DIA	ETF	131.0	131.1	129.57	129.65	467400.0
2008-01-04 09:00:00	DIA	ETF	129.65	129.73	129.06	129.22	2325749.0
2008-01-04 10:00:00	DIA	ETF	129.22	129.52	128.41	128.45	3004153.0
2008-01-04 11:00:00	DIA	ETF	128.46	128.92	128.35	128.86	1866876.0
2008-01-04 12:00:00	DIA	ETF	128.86	129.14	128.49	128.65	1923781.0
2008-01-04 13:00:00	DIA	ETF	128.66	128.76	128.22	128.64	1150261.0
2008-01-04 14:00:00	DIA	ETF	128.61	128.61	127.86	128.21	1630272.0

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

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