PREVIEW / etf_1hour / 2007-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-05.parquet
  size:    67 KB
  rows:    2,156

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-04-05 04:00:00	SPY	ETF	143.76	143.76	143.76	143.76	100.0
2007-04-05 06:00:00	SPY	ETF	143.76	143.76	143.76	143.76	5000.0
2007-04-05 07:00:00	SPY	ETF	143.8	143.82	143.76	143.82	14700.0
2007-04-05 08:00:00	SPY	ETF	143.82	143.86	143.76	143.76	392600.0
2007-04-05 09:00:00	SPY	ETF	143.77	143.84	143.61	143.75	5395600.0
2007-04-05 10:00:00	SPY	ETF	143.74	143.93	143.69	143.9	7142925.0
2007-04-05 11:00:00	SPY	ETF	143.9	144.11	143.84	144.1	5863850.0
2007-04-05 12:00:00	SPY	ETF	144.1	144.25	144.08	144.11	4799800.0
2007-04-05 13:00:00	SPY	ETF	144.12	144.36	143.92	144.29	5247325.0
2007-04-05 14:00:00	SPY	ETF	144.28	144.44	144.25	144.32	4747400.0
2007-04-05 15:00:00	SPY	ETF	144.32	144.41	144.21	144.28	10210540.0
2007-04-05 16:00:00	SPY	ETF	144.3	144.37	144.22	144.27	2026800.0
2007-04-05 17:00:00	SPY	ETF	144.28	144.31	144.27	144.27	116100.0
2007-04-05 18:00:00	SPY	ETF	144.3	144.3	144.25	144.25	20500.0
2007-04-05 19:00:00	SPY	ETF	144.29	144.31	144.29	144.31	28400.0
2007-04-05 05:00:00	QQQ	ETF	44.29	44.29	44.28	44.28	8040.0
2007-04-05 06:00:00	QQQ	ETF	44.29	44.29	44.29	44.29	1960.0
2007-04-05 07:00:00	QQQ	ETF	44.31	44.34	44.29	44.33	76650.0
2007-04-05 08:00:00	QQQ	ETF	44.34	44.35	44.32	44.32	158849.0
2007-04-05 09:00:00	QQQ	ETF	44.32	44.36	44.23	44.32	6818465.0
2007-04-05 10:00:00	QQQ	ETF	44.33	44.37	44.3	44.33	6099000.0
2007-04-05 11:00:00	QQQ	ETF	44.33	44.39	44.3	44.39	5700900.0
2007-04-05 12:00:00	QQQ	ETF	44.4	44.45	44.38	44.39	4102000.0
2007-04-05 13:00:00	QQQ	ETF	44.39	44.46	44.39	44.44	5461600.0
2007-04-05 14:00:00	QQQ	ETF	44.44	44.51	44.42	44.48	5322300.0
2007-04-05 15:00:00	QQQ	ETF	44.48	44.57	44.3	44.57	11217900.0
2007-04-05 16:00:00	QQQ	ETF	44.58	44.62	44.52	44.57	8689474.0
2007-04-05 17:00:00	QQQ	ETF	44.58	44.58	44.55	44.56	13767.0
2007-04-05 18:00:00	QQQ	ETF	44.57	44.6	44.57	44.58	20500.0
2007-04-05 19:00:00	QQQ	ETF	44.59	44.6	44.57	44.6	15250.0
2007-04-05 08:00:00	IWM	ETF	80.57	80.57	80.5	80.5	200.0
2007-04-05 09:00:00	IWM	ETF	80.49	80.57	80.35	80.52	1496700.0
2007-04-05 10:00:00	IWM	ETF	80.52	80.651	80.48	80.59	4768900.0
2007-04-05 11:00:00	IWM	ETF	80.59	80.63	80.48	80.63	3200200.0
2007-04-05 12:00:00	IWM	ETF	80.64	80.71	80.6	80.64	4321617.0
2007-04-05 13:00:00	IWM	ETF	80.63	80.75	80.63	80.66	3606646.0
2007-04-05 14:00:00	IWM	ETF	80.65	80.77	80.65	80.74	1594600.0
2007-04-05 15:00:00	IWM	ETF	80.73	80.81	80.64	80.67	3136953.0
2007-04-05 16:00:00	IWM	ETF	80.67	80.68	80.46	80.5	1416200.0
2007-04-05 17:00:00	IWM	ETF	80.49	80.52	80.49	80.51	5400.0
2007-04-05 18:00:00	IWM	ETF	80.5	80.51	80.5	80.51	800.0
2007-04-05 19:00:00	IWM	ETF	80.51	80.51	80.51	80.51	600.0
2007-04-05 07:00:00	DIA	ETF	125.23	125.28	125.23	125.28	99900.0
2007-04-05 08:00:00	DIA	ETF	125.22	125.25	125.2	125.2	3000.0
2007-04-05 09:00:00	DIA	ETF	125.17	125.19	125.01	125.03	513560.0
2007-04-05 10:00:00	DIA	ETF	125.04	125.28	124.95	125.22	1067400.0
2007-04-05 11:00:00	DIA	ETF	125.23	125.35	125.17	125.34	498570.0
2007-04-05 12:00:00	DIA	ETF	125.35	125.46	125.34	125.44	259000.0
2007-04-05 13:00:00	DIA	ETF	125.43	125.63	125.43	125.59	296979.0
2007-04-05 14:00:00	DIA	ETF	125.59	125.7	125.56	125.63	310160.0

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

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