PREVIEW / etf_1hour / 2008-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-14.parquet
  size:    105 KB
  rows:    3,390

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-14 04:00:00	SPY	ETF	140.72	140.72	140.72	140.72	200.0
2008-05-14 06:00:00	SPY	ETF	140.4	140.44	140.24	140.4	128100.0
2008-05-14 07:00:00	SPY	ETF	140.41	140.41	139.99	140.33	552326.0
2008-05-14 08:00:00	SPY	ETF	140.35	141.3	140.25	141.14	7262049.0
2008-05-14 09:00:00	SPY	ETF	141.12	142.0	141.01	141.49	27962331.0
2008-05-14 10:00:00	SPY	ETF	141.48	141.82	141.37	141.62	26207619.0
2008-05-14 11:00:00	SPY	ETF	141.62	141.8	141.44	141.67	12230263.0
2008-05-14 12:00:00	SPY	ETF	141.67	141.85	141.59	141.75	9329366.0
2008-05-14 13:00:00	SPY	ETF	141.75	142.2	141.73	142.05	16074474.0
2008-05-14 14:00:00	SPY	ETF	142.05	142.15	141.81	141.83	21964473.0
2008-05-14 15:00:00	SPY	ETF	141.83	141.93	140.88	140.96	47939352.0
2008-05-14 16:00:00	SPY	ETF	141.01	141.77	140.64	140.74	7646129.0
2008-05-14 17:00:00	SPY	ETF	140.78	140.83	140.46	140.81	2375783.0
2008-05-14 18:00:00	SPY	ETF	140.78	140.88	140.78	140.86	36626.0
2008-05-14 19:00:00	SPY	ETF	140.86	140.88	140.81	140.81	7366.0
2008-05-14 04:00:00	QQQ	ETF	49.3	49.3	49.3	49.3	1000.0
2008-05-14 06:00:00	QQQ	ETF	49.16	49.16	49.15	49.15	3000.0
2008-05-14 07:00:00	QQQ	ETF	49.21	49.21	49.11	49.18	24000.0
2008-05-14 08:00:00	QQQ	ETF	49.18	49.51	49.16	49.46	3089088.0
2008-05-14 09:00:00	QQQ	ETF	49.46	49.71	49.38	49.67	17216820.0
2008-05-14 10:00:00	QQQ	ETF	49.68	49.88	49.64	49.75	17547153.0
2008-05-14 11:00:00	QQQ	ETF	49.7504	49.77	49.6	49.69	10167002.0
2008-05-14 12:00:00	QQQ	ETF	49.69	49.79	49.62	49.7	6724628.0
2008-05-14 13:00:00	QQQ	ETF	49.69	49.93	49.69	49.87	12177600.0
2008-05-14 14:00:00	QQQ	ETF	49.87	49.92	49.66	49.67	17965598.0
2008-05-14 15:00:00	QQQ	ETF	49.67	49.68	49.04	49.1	46170513.0
2008-05-14 16:00:00	QQQ	ETF	49.1	49.5745	49.01	49.06	2927692.0
2008-05-14 17:00:00	QQQ	ETF	49.07	49.11	49.04	49.07	85162.0
2008-05-14 18:00:00	QQQ	ETF	49.08	49.08	49.05	49.06	37016.0
2008-05-14 19:00:00	QQQ	ETF	49.08	49.09	49.05	49.09	29425.0
2008-05-14 07:00:00	IWM	ETF	73.36	73.41	73.26	73.41	36154.0
2008-05-14 08:00:00	IWM	ETF	73.4	73.79	73.4	73.67	1574287.0
2008-05-14 09:00:00	IWM	ETF	73.66	73.95	73.47	73.87	5077146.0
2008-05-14 10:00:00	IWM	ETF	73.87	74.07	73.77	74.01	8056754.0
2008-05-14 11:00:00	IWM	ETF	74.01	74.19	73.88	74.14	6379843.0
2008-05-14 12:00:00	IWM	ETF	74.14	74.23	73.75	74.14	3681898.0
2008-05-14 13:00:00	IWM	ETF	74.14	74.35	74.11	74.32	6128700.0
2008-05-14 14:00:00	IWM	ETF	74.31	74.33	74.04	74.06	4791987.0
2008-05-14 15:00:00	IWM	ETF	74.05	74.06	72.6	73.4	12960922.0
2008-05-14 16:00:00	IWM	ETF	73.4	73.86	73.36	73.37	7979459.0
2008-05-14 17:00:00	IWM	ETF	73.33	73.4	73.31	73.4	1259736.0
2008-05-14 07:00:00	DIA	ETF	127.97	128.21	127.97	128.21	1700.0
2008-05-14 08:00:00	DIA	ETF	128.26	128.92	128.22	128.82	217558.0
2008-05-14 09:00:00	DIA	ETF	128.84	129.53	128.75	129.47	1276913.0
2008-05-14 10:00:00	DIA	ETF	129.47	129.81	129.38	129.62	2340170.0
2008-05-14 11:00:00	DIA	ETF	129.63	129.74	129.42	129.62	999525.0
2008-05-14 12:00:00	DIA	ETF	129.62	129.75	129.55	129.72	691363.0
2008-05-14 13:00:00	DIA	ETF	129.71	130.08	129.69	129.97	1613384.0
2008-05-14 14:00:00	DIA	ETF	129.98	130.04	129.78	129.8	1160826.0
2008-05-14 15:00:00	DIA	ETF	129.78	129.83	129.04	129.04	3246334.0

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

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