PREVIEW / etf_1hour / 2007-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-07.parquet
  size:    64 KB
  rows:    2,048

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-02-07 06:00:00	SPY	ETF	145.01	145.01	145.0	145.0	15100.0
2007-02-07 07:00:00	SPY	ETF	144.93	145.08	144.93	145.08	134700.0
2007-02-07 08:00:00	SPY	ETF	145.07	145.2	144.99	145.16	663800.0
2007-02-07 09:00:00	SPY	ETF	145.16	145.19	144.87	144.96	7585100.0
2007-02-07 10:00:00	SPY	ETF	144.96	145.34	144.87	145.25	10336700.0
2007-02-07 11:00:00	SPY	ETF	145.25	145.34	145.18	145.27	3640800.0
2007-02-07 12:00:00	SPY	ETF	145.26	145.36	145.2	145.3	4443800.0
2007-02-07 13:00:00	SPY	ETF	145.29	145.36	145.13	145.16	6754900.0
2007-02-07 14:00:00	SPY	ETF	145.16	145.21	144.57	144.755	9774800.0
2007-02-07 15:00:00	SPY	ETF	144.75	145.06	144.75	145.03	8584700.0
2007-02-07 16:00:00	SPY	ETF	145.04	145.21	144.99	145.13	748200.0
2007-02-07 17:00:00	SPY	ETF	145.13	145.19	145.12	145.17	45800.0
2007-02-07 18:00:00	SPY	ETF	145.17	145.17	145.12	145.12	22800.0
2007-02-07 19:00:00	SPY	ETF	145.12	145.12	145.11	145.11	1400.0
2007-02-07 04:00:00	QQQ	ETF	44.24	44.24	44.24	44.24	100.0
2007-02-07 05:00:00	QQQ	ETF	44.26	44.26	44.23	44.23	200.0
2007-02-07 07:00:00	QQQ	ETF	44.24	44.31	44.24	44.3	33128.0
2007-02-07 08:00:00	QQQ	ETF	44.29	44.35	44.26	44.32	2433653.0
2007-02-07 09:00:00	QQQ	ETF	44.33	44.35	44.12	44.19	14831605.0
2007-02-07 10:00:00	QQQ	ETF	44.19	44.61	44.12	44.58	29651600.0
2007-02-07 11:00:00	QQQ	ETF	44.58	44.65	44.51	44.53	12868000.0
2007-02-07 12:00:00	QQQ	ETF	44.53	44.63	44.53	44.59	5959600.0
2007-02-07 13:00:00	QQQ	ETF	44.59	44.65	44.51	44.52	7737900.0
2007-02-07 14:00:00	QQQ	ETF	44.52	44.55	44.27	44.34	22885500.0
2007-02-07 15:00:00	QQQ	ETF	44.34	44.5	44.33	44.49	15703500.0
2007-02-07 16:00:00	QQQ	ETF	44.49	44.6	44.48	44.57	3756683.0
2007-02-07 17:00:00	QQQ	ETF	44.57	44.59	44.54	44.55	412902.0
2007-02-07 18:00:00	QQQ	ETF	44.55	44.56	44.51	44.51	135725.0
2007-02-07 19:00:00	QQQ	ETF	44.53	44.53	44.51	44.53	55557.0
2007-02-07 08:00:00	IWM	ETF	80.54	80.61	80.54	80.57	382800.0
2007-02-07 09:00:00	IWM	ETF	80.58	80.6	80.28	80.37	2201400.0
2007-02-07 10:00:00	IWM	ETF	80.37	80.91	80.33	80.81	5248500.0
2007-02-07 11:00:00	IWM	ETF	80.81	81.14	80.75	80.79	3310800.0
2007-02-07 12:00:00	IWM	ETF	80.79	80.93	80.78	80.88	1778900.0
2007-02-07 13:00:00	IWM	ETF	80.88	80.98	80.78	80.8	2741600.0
2007-02-07 14:00:00	IWM	ETF	80.81	80.86	80.57	80.69	5064900.0
2007-02-07 15:00:00	IWM	ETF	80.7	81.02	80.69	80.98	8285600.0
2007-02-07 16:00:00	IWM	ETF	80.98	81.27	80.98	81.2	297200.0
2007-02-07 19:00:00	IWM	ETF	81.11	81.11	81.11	81.11	1000.0
2007-02-07 08:00:00	DIA	ETF	126.77	126.86	126.75	126.85	19700.0
2007-02-07 09:00:00	DIA	ETF	126.8	126.83	126.61	126.71	567000.0
2007-02-07 10:00:00	DIA	ETF	126.72	127.04	126.66	126.96	1145200.0
2007-02-07 11:00:00	DIA	ETF	126.97	127.06	126.85	126.93	647500.0
2007-02-07 12:00:00	DIA	ETF	126.93	127.0	126.89	126.97	442500.0
2007-02-07 13:00:00	DIA	ETF	126.97	127.03	126.76	126.77	637100.0
2007-02-07 14:00:00	DIA	ETF	126.77	126.82	126.33	126.4	1296500.0
2007-02-07 15:00:00	DIA	ETF	126.4	126.73	126.4	126.71	1053100.0
2007-02-07 16:00:00	DIA	ETF	126.7025	126.82	126.69	126.78	61300.0
2007-02-07 18:00:00	DIA	ETF	126.79	126.79	126.76	126.76	1200.0
2007-02-07 08:00:00	GLD	ETF	64.81	64.97	64.71	64.85	110300.0

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

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