PREVIEW / etf_1hour / 2007-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-31.parquet
  size:    64 KB
  rows:    2,004

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
2007-01-31 04:00:00	SPY	ETF	142.6	142.6	142.6	142.6	800.0
2007-01-31 07:00:00	SPY	ETF	142.52	142.61	142.46	142.56	79300.0
2007-01-31 08:00:00	SPY	ETF	142.58	142.78	142.52	142.62	3168400.0
2007-01-31 09:00:00	SPY	ETF	142.62	142.7	142.4	142.46	5916600.0
2007-01-31 10:00:00	SPY	ETF	142.46	143.01	142.42	142.9	10785200.0
2007-01-31 11:00:00	SPY	ETF	142.89	142.94	142.74	142.88	5540000.0
2007-01-31 12:00:00	SPY	ETF	142.88	142.93	142.69	142.83	5247700.0
2007-01-31 13:00:00	SPY	ETF	142.84	142.92	142.79	142.86	2437900.0
2007-01-31 14:00:00	SPY	ETF	142.87	143.91	142.66	143.81	32034000.0
2007-01-31 15:00:00	SPY	ETF	143.81	144.13	143.71	143.81	19338400.0
2007-01-31 16:00:00	SPY	ETF	143.82	143.85	143.59	143.74	3224200.0
2007-01-31 17:00:00	SPY	ETF	143.72	143.8	143.67	143.76	60000.0
2007-01-31 18:00:00	SPY	ETF	143.8	143.8	143.74	143.74	17500.0
2007-01-31 19:00:00	SPY	ETF	143.74	143.8	143.72	143.8	17100.0
2007-01-31 06:00:00	QQQ	ETF	43.57	43.57	43.57	43.57	50000.0
2007-01-31 07:00:00	QQQ	ETF	43.55	43.59	43.55	43.58	85100.0
2007-01-31 08:00:00	QQQ	ETF	43.57	43.65	43.53	43.61	2736141.0
2007-01-31 09:00:00	QQQ	ETF	43.62	43.64	43.33	43.38	21005634.0
2007-01-31 10:00:00	QQQ	ETF	43.39	43.87	43.37	43.77	27801900.0
2007-01-31 11:00:00	QQQ	ETF	43.77	43.78	43.65	43.71	11076100.0
2007-01-31 12:00:00	QQQ	ETF	43.72	43.74	43.61	43.69	5823500.0
2007-01-31 13:00:00	QQQ	ETF	43.69	43.72	43.62	43.65	5461800.0
2007-01-31 14:00:00	QQQ	ETF	43.65	44.04	43.56	43.99	33530400.0
2007-01-31 15:00:00	QQQ	ETF	43.99	44.19	43.95	44.06	27685300.0
2007-01-31 16:00:00	QQQ	ETF	44.06	44.1	43.85	44.03	11697293.0
2007-01-31 17:00:00	QQQ	ETF	44.03	44.1	44.02	44.07	535382.0
2007-01-31 18:00:00	QQQ	ETF	44.07	44.1	44.06	44.1	126753.0
2007-01-31 19:00:00	QQQ	ETF	44.07	44.09	44.07	44.08	6540.0
2007-01-31 07:00:00	IWM	ETF	78.97	78.98	78.9	78.98	8500.0
2007-01-31 08:00:00	IWM	ETF	78.97	79.1	78.92	78.95	947600.0
2007-01-31 09:00:00	IWM	ETF	78.97	79.15	78.63	78.72	5685400.0
2007-01-31 10:00:00	IWM	ETF	78.72	79.2	78.67	79.06	6675200.0
2007-01-31 11:00:00	IWM	ETF	79.06	79.12	78.89	79.03	2203200.0
2007-01-31 12:00:00	IWM	ETF	79.03	79.06	78.79	78.93	3820000.0
2007-01-31 13:00:00	IWM	ETF	78.92	79.11	78.88	79.0	3991700.0
2007-01-31 14:00:00	IWM	ETF	79.01	79.69	78.9	79.61	13692300.0
2007-01-31 15:00:00	IWM	ETF	79.62	79.77	79.33	79.34	12768300.0
2007-01-31 16:00:00	IWM	ETF	79.33	79.43	79.18	79.29	1946600.0
2007-01-31 17:00:00	IWM	ETF	79.31	79.37	79.31	79.37	22500.0
2007-01-31 18:00:00	IWM	ETF	78.76	79.35	78.76	79.35	2100.0
2007-01-31 07:00:00	DIA	ETF	125.03	125.06	125.03	125.06	1300.0
2007-01-31 08:00:00	DIA	ETF	125.1	125.25	125.08	125.14	99200.0
2007-01-31 09:00:00	DIA	ETF	125.16	125.33	125.13	125.18	818800.0
2007-01-31 10:00:00	DIA	ETF	125.17	125.65	125.16	125.5	1343000.0
2007-01-31 11:00:00	DIA	ETF	125.5	125.5	125.34	125.41	445000.0
2007-01-31 12:00:00	DIA	ETF	125.4	125.44	125.28	125.42	505800.0
2007-01-31 13:00:00	DIA	ETF	125.41	125.44	125.35	125.41	365200.0
2007-01-31 14:00:00	DIA	ETF	125.41	126.32	125.33	126.21	3887500.0
2007-01-31 15:00:00	DIA	ETF	126.2174	126.49	126.09	126.21	2212200.0
2007-01-31 16:00:00	DIA	ETF	126.2	126.23	126.05	126.15	65200.0

> showing 50 of 2,004 rows — these rows as CSV

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