PREVIEW / etf_1hour / 2008-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-21.parquet
  size:    110 KB
  rows:    3,502

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-05-21 04:00:00	SPY	ETF	142.14	142.17	142.14	142.17	1700.0
2008-05-21 05:00:00	SPY	ETF	142.25	142.25	142.23	142.25	2700.0
2008-05-21 06:00:00	SPY	ETF	141.87	141.87	141.61	141.82	51100.0
2008-05-21 07:00:00	SPY	ETF	141.84	141.91	141.25	141.66	849867.0
2008-05-21 08:00:00	SPY	ETF	141.63	142.26	141.37	141.69	1752189.0
2008-05-21 09:00:00	SPY	ETF	141.71	142.12	141.64	141.69	21871451.0
2008-05-21 10:00:00	SPY	ETF	141.68	141.9	141.04	141.1	39415010.0
2008-05-21 11:00:00	SPY	ETF	141.09	141.55	140.99	141.44	23188450.0
2008-05-21 12:00:00	SPY	ETF	141.44	141.74	141.29	141.545	17186998.0
2008-05-21 13:00:00	SPY	ETF	141.56	141.58	140.78	140.88	20438967.0
2008-05-21 14:00:00	SPY	ETF	140.89	140.91	139.0	139.75	64432678.0
2008-05-21 15:00:00	SPY	ETF	139.75	139.96	139.04	139.3	45564482.0
2008-05-21 16:00:00	SPY	ETF	139.31	142.26	139.22	139.46	12540252.0
2008-05-21 17:00:00	SPY	ETF	139.44	139.62	139.42	139.6	1128217.0
2008-05-21 18:00:00	SPY	ETF	139.6	139.6	139.47	139.49	33071.0
2008-05-21 19:00:00	SPY	ETF	139.5	139.5	139.38	139.41	15400.0
2008-05-21 06:00:00	QQQ	ETF	49.3	49.3	49.29	49.29	2600.0
2008-05-21 07:00:00	QQQ	ETF	49.32	49.33	49.09	49.19	568370.0
2008-05-21 08:00:00	QQQ	ETF	49.19	49.23	49.13	49.23	646561.0
2008-05-21 09:00:00	QQQ	ETF	49.21	49.6	49.19	49.33	18354620.0
2008-05-21 10:00:00	QQQ	ETF	49.33	49.49	49.0	49.035	32268633.0
2008-05-21 11:00:00	QQQ	ETF	49.0326	49.14	48.92	49.08	22936830.0
2008-05-21 12:00:00	QQQ	ETF	49.08	49.27	49.01	49.22	10305547.0
2008-05-21 13:00:00	QQQ	ETF	49.22	49.2284	48.8	48.8205	12788892.0
2008-05-21 14:00:00	QQQ	ETF	48.82	48.8288	48.12	48.33	44903296.0
2008-05-21 15:00:00	QQQ	ETF	48.33	48.44	48.02	48.1999	35960307.0
2008-05-21 16:00:00	QQQ	ETF	48.18	48.7363	48.07	48.29	9298707.0
2008-05-21 17:00:00	QQQ	ETF	48.28	48.3	48.27	48.27	29792.0
2008-05-21 18:00:00	QQQ	ETF	48.28	48.29	48.23	48.26	13074.0
2008-05-21 19:00:00	QQQ	ETF	48.27	48.27	48.2	48.2	16243.0
2008-05-21 07:00:00	IWM	ETF	73.65	73.67	73.37	73.51	125990.0
2008-05-21 08:00:00	IWM	ETF	73.53	73.61	73.41	73.56	457742.0
2008-05-21 09:00:00	IWM	ETF	73.59	74.23	73.56	73.8	10521512.0
2008-05-21 10:00:00	IWM	ETF	73.8	73.94	73.53	73.61	12901061.0
2008-05-21 11:00:00	IWM	ETF	73.62	73.81	73.34	73.74	10000623.0
2008-05-21 12:00:00	IWM	ETF	73.74	74.05	73.62	73.98	7734167.0
2008-05-21 13:00:00	IWM	ETF	73.99	74.0	73.41	73.47	6527817.0
2008-05-21 14:00:00	IWM	ETF	73.47	73.47	72.25	72.56	22653895.0
2008-05-21 15:00:00	IWM	ETF	72.56	72.97	72.44	72.63	17356509.0
2008-05-21 16:00:00	IWM	ETF	72.63	73.45	72.56	72.63	6401563.0
2008-05-21 17:00:00	IWM	ETF	72.85	72.86	72.79	72.8	18988.0
2008-05-21 18:00:00	IWM	ETF	72.81	72.9	72.8	72.8	3300.0
2008-05-21 19:00:00	IWM	ETF	72.8	72.8	72.78	72.78	350.0
2008-05-21 07:00:00	DIA	ETF	127.99	128.2	127.99	128.2	2798.0
2008-05-21 08:00:00	DIA	ETF	128.23	128.4	128.18	128.32	24888.0
2008-05-21 09:00:00	DIA	ETF	128.36	128.56	128.0	128.02	1658956.0
2008-05-21 10:00:00	DIA	ETF	128.01	128.17	127.3	127.33	2593246.0
2008-05-21 11:00:00	DIA	ETF	127.33	127.75	127.17	127.66	1653472.0
2008-05-21 12:00:00	DIA	ETF	127.66	127.85	127.54	127.69	1298504.0
2008-05-21 13:00:00	DIA	ETF	127.7	127.71	127.1	127.18	1377835.0

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

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