PREVIEW / etf_1hour / 2008-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-05.parquet
  size:    101 KB
  rows:    3,376

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-02-05 04:00:00	SPY	ETF	137.75	137.75	137.54	137.57	2200.0
2008-02-05 05:00:00	SPY	ETF	137.67	137.67	137.65	137.65	50000.0
2008-02-05 06:00:00	SPY	ETF	137.71	137.71	137.51	137.64	32200.0
2008-02-05 07:00:00	SPY	ETF	137.57	137.57	137.05	137.13	2211100.0
2008-02-05 08:00:00	SPY	ETF	137.19	137.82	135.66	135.7	13836822.0
2008-02-05 09:00:00	SPY	ETF	135.7	137.0736	135.21	136.05	45263176.0
2008-02-05 10:00:00	SPY	ETF	136.05	136.25	135.18	135.44	43189262.0
2008-02-05 11:00:00	SPY	ETF	135.44	135.86	134.88	135.69	28029630.0
2008-02-05 12:00:00	SPY	ETF	135.7	135.74	134.78	135.03	22675336.0
2008-02-05 13:00:00	SPY	ETF	135.02	135.37	134.29	134.52	27854655.0
2008-02-05 14:00:00	SPY	ETF	134.52	135.14	134.09	134.48	28116755.0
2008-02-05 15:00:00	SPY	ETF	134.48	134.6	133.68	133.7	49022814.0
2008-02-05 16:00:00	SPY	ETF	133.71	135.0272	133.7	134.25	11688821.0
2008-02-05 17:00:00	SPY	ETF	134.25	134.41	134.15	134.3	10836200.0
2008-02-05 18:00:00	SPY	ETF	134.26	134.27	134.12	134.25	143100.0
2008-02-05 19:00:00	SPY	ETF	134.2	134.47	134.18	134.25	107200.0
2008-02-05 07:00:00	QQQ	ETF	44.8	44.8	44.66	44.68	104072.0
2008-02-05 08:00:00	QQQ	ETF	44.67	44.76	44.2	44.21	4039638.0
2008-02-05 09:00:00	QQQ	ETF	44.2	44.55	44.1	44.51	29299769.0
2008-02-05 10:00:00	QQQ	ETF	44.51	44.6	44.23	44.33	25436546.0
2008-02-05 11:00:00	QQQ	ETF	44.33	44.45	44.2	44.39	14516475.0
2008-02-05 12:00:00	QQQ	ETF	44.39	44.4099	44.11	44.15	18340821.0
2008-02-05 13:00:00	QQQ	ETF	44.14	44.231	43.79	43.91	26634958.0
2008-02-05 14:00:00	QQQ	ETF	43.92	44.11	43.8	43.87	21989768.0
2008-02-05 15:00:00	QQQ	ETF	43.87	43.91	43.64	43.67	39992466.0
2008-02-05 16:00:00	QQQ	ETF	43.66	44.0937	43.62	43.87	7305585.0
2008-02-05 17:00:00	QQQ	ETF	43.87	43.91	43.6699	43.84	1222852.0
2008-02-05 18:00:00	QQQ	ETF	43.84	43.84	43.81	43.83	35233.0
2008-02-05 19:00:00	QQQ	ETF	43.82	43.88	43.81	43.82	72196.0
2008-02-05 04:00:00	IWM	ETF	71.75	71.75	71.75	71.75	1000.0
2008-02-05 06:00:00	IWM	ETF	71.69	71.69	71.69	71.69	200.0
2008-02-05 07:00:00	IWM	ETF	71.63	71.63	71.2	71.21	250800.0
2008-02-05 08:00:00	IWM	ETF	71.28	71.39	70.4	70.42	2597700.0
2008-02-05 09:00:00	IWM	ETF	70.47	71.37	70.47	71.23	24269996.0
2008-02-05 10:00:00	IWM	ETF	71.22	71.57	71.01	71.17	14035958.0
2008-02-05 11:00:00	IWM	ETF	71.16	71.38	70.75	71.22	12351504.0
2008-02-05 12:00:00	IWM	ETF	71.21	71.26	70.7	70.88	8431752.0
2008-02-05 13:00:00	IWM	ETF	70.88	71.11	70.39	70.51	13391968.0
2008-02-05 14:00:00	IWM	ETF	70.51	70.83	70.22	70.47	10155938.0
2008-02-05 15:00:00	IWM	ETF	70.47	70.48	69.8	69.91	28823104.0
2008-02-05 16:00:00	IWM	ETF	69.91	71.15	69.88	70.33	11948800.0
2008-02-05 17:00:00	IWM	ETF	70.36	70.46	70.3	70.3	278900.0
2008-02-05 18:00:00	IWM	ETF	70.31	70.33	70.3	70.3	7000.0
2008-02-05 19:00:00	IWM	ETF	70.39	70.39	70.36	70.36	2500.0
2008-02-05 07:00:00	DIA	ETF	125.85	125.85	125.55	125.56	2700.0
2008-02-05 08:00:00	DIA	ETF	125.58	125.73	124.5	124.5	50200.0
2008-02-05 09:00:00	DIA	ETF	124.52	124.88	124.0	124.59	2548531.0
2008-02-05 10:00:00	DIA	ETF	124.58	124.61	123.76	123.97	2812909.0
2008-02-05 11:00:00	DIA	ETF	123.98	124.34	123.62	124.18	1755179.0
2008-02-05 12:00:00	DIA	ETF	124.18	124.21	123.41	123.61	1463476.0

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

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