PREVIEW / etf_1hour / 2007-02-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-27.parquet
  size:    75 KB
  rows:    2,306

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-27 04:00:00	SPY	ETF	144.52	144.52	144.47	144.47	3900.0
2007-02-27 06:00:00	SPY	ETF	144.6	144.6	144.44	144.48	303300.0
2007-02-27 07:00:00	SPY	ETF	144.5	144.5	144.15	144.32	1307500.0
2007-02-27 08:00:00	SPY	ETF	144.29	144.58	143.89	143.93	3628300.0
2007-02-27 09:00:00	SPY	ETF	143.94	144.2	143.31	143.58	26282900.0
2007-02-27 10:00:00	SPY	ETF	143.59	144.2	143.44	143.44	25138400.0
2007-02-27 11:00:00	SPY	ETF	143.45	143.63	143.15	143.18	15928600.0
2007-02-27 12:00:00	SPY	ETF	143.18	143.21	142.65	142.92	22458900.0
2007-02-27 13:00:00	SPY	ETF	142.9099	142.98	142.27	142.37	25105200.0
2007-02-27 14:00:00	SPY	ETF	142.37	142.4	139.1	139.98	54741800.0
2007-02-27 15:00:00	SPY	ETF	139.98	141.36	139.0	140.005	70807400.0
2007-02-27 16:00:00	SPY	ETF	140.0422	140.31	139.1	139.3	5420300.0
2007-02-27 17:00:00	SPY	ETF	139.27	140.1	139.1	139.36	2491300.0
2007-02-27 18:00:00	SPY	ETF	139.36	139.75	139.34	139.4	430100.0
2007-02-27 19:00:00	SPY	ETF	139.4	139.75	139.38	139.54	31800.0
2007-02-27 04:00:00	QQQ	ETF	44.77	44.77	44.71	44.72	3700.0
2007-02-27 06:00:00	QQQ	ETF	44.67	44.67	44.67	44.67	2500.0
2007-02-27 07:00:00	QQQ	ETF	44.7	44.71	44.57	44.61	1103487.0
2007-02-27 08:00:00	QQQ	ETF	44.61	44.64	44.37	44.38	4325763.0
2007-02-27 09:00:00	QQQ	ETF	44.38	44.42	44.08	44.36	31009462.0
2007-02-27 10:00:00	QQQ	ETF	44.36	44.48	44.28	44.29	31201800.0
2007-02-27 11:00:00	QQQ	ETF	44.3	44.38	44.15	44.15	24432700.0
2007-02-27 12:00:00	QQQ	ETF	44.15	44.16	43.91	44.03	41114800.0
2007-02-27 13:00:00	QQQ	ETF	44.04	44.04	43.77	43.78	32972200.0
2007-02-27 14:00:00	QQQ	ETF	43.78	43.81	43.14	43.28	68050700.0
2007-02-27 15:00:00	QQQ	ETF	43.28	43.71	43.06	43.2	70340300.0
2007-02-27 16:00:00	QQQ	ETF	43.2	43.4	42.81	42.86	8064624.0
2007-02-27 17:00:00	QQQ	ETF	42.86	42.92	42.79	42.86	481135.0
2007-02-27 18:00:00	QQQ	ETF	42.85	42.94	42.85	42.89	135110.0
2007-02-27 19:00:00	QQQ	ETF	42.89	42.95	42.85	42.89	116797.0
2007-02-27 07:00:00	IWM	ETF	81.0	81.0	80.6	80.79	54300.0
2007-02-27 08:00:00	IWM	ETF	80.85	80.92	80.46	80.48	3498100.0
2007-02-27 09:00:00	IWM	ETF	80.47	80.51	79.75	80.23	13500015.0
2007-02-27 10:00:00	IWM	ETF	80.24	80.94	80.0	80.24	18346700.0
2007-02-27 11:00:00	IWM	ETF	80.24	80.4	80.07	80.13	11588600.0
2007-02-27 12:00:00	IWM	ETF	80.14	80.22	79.87	80.07	10971600.0
2007-02-27 13:00:00	IWM	ETF	80.08	80.11	79.58	79.65	10852900.0
2007-02-27 14:00:00	IWM	ETF	79.64	79.67	78.1	78.78	21268500.0
2007-02-27 15:00:00	IWM	ETF	78.9	79.91	77.47	78.44	38645000.0
2007-02-27 16:00:00	IWM	ETF	78.45	78.53	77.84	77.94	1131900.0
2007-02-27 17:00:00	IWM	ETF	77.9	78.55	77.83	77.9	464500.0
2007-02-27 18:00:00	IWM	ETF	77.88	78.15	77.88	77.91	150700.0
2007-02-27 19:00:00	IWM	ETF	77.92	78.06	77.92	78.06	3000.0
2007-02-27 07:00:00	DIA	ETF	125.77	125.77	125.6	125.65	39600.0
2007-02-27 08:00:00	DIA	ETF	125.69	125.75	125.46	125.46	171100.0
2007-02-27 09:00:00	DIA	ETF	125.43	126.44	124.71	125.1	1755800.0
2007-02-27 10:00:00	DIA	ETF	125.09	125.39	124.9	124.93	2741800.0
2007-02-27 11:00:00	DIA	ETF	124.93	125.04	124.66	124.66	1514000.0
2007-02-27 12:00:00	DIA	ETF	124.65	124.68	124.41	124.53	2484300.0
2007-02-27 13:00:00	DIA	ETF	124.54	124.6	124.08	124.13	3043100.0

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

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