PREVIEW / etf_1hour / 2008-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-11-19.parquet
  size:    114 KB
  rows:    3,771

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-11-19 04:00:00	SPY	ETF	85.52	86.28	85.25	85.25	1700.0
2008-11-19 05:00:00	SPY	ETF	85.66	86.31	85.62	86.25	900.0
2008-11-19 06:00:00	SPY	ETF	85.99	86.02	85.63	86.0	41700.0
2008-11-19 07:00:00	SPY	ETF	86.01	86.24	85.43	85.43	2620175.0
2008-11-19 08:00:00	SPY	ETF	85.43	87.08	84.93	85.16	6661460.0
2008-11-19 09:00:00	SPY	ETF	85.17	86.78	85.09	85.59	51582072.0
2008-11-19 10:00:00	SPY	ETF	85.6	86.87	84.29	84.38	65170858.0
2008-11-19 11:00:00	SPY	ETF	84.37	84.84	83.26	83.82	58626030.0
2008-11-19 12:00:00	SPY	ETF	83.83	83.96	83.03	83.77	49783436.0
2008-11-19 13:00:00	SPY	ETF	83.79	84.31	82.69	83.67	56282105.0
2008-11-19 14:00:00	SPY	ETF	83.67	86.2427	82.38	83.8	84102136.0
2008-11-19 15:00:00	SPY	ETF	83.8	84.11	80.92	81.13	154073312.0
2008-11-19 16:00:00	SPY	ETF	81.22	84.78	80.92	81.31	24603681.0
2008-11-19 17:00:00	SPY	ETF	81.31	81.68	81.3	81.49	854367.0
2008-11-19 18:00:00	SPY	ETF	81.55	81.74	81.23	81.7	365312.0
2008-11-19 19:00:00	SPY	ETF	81.71	81.82	81.2	81.55	191646.0
2008-11-19 04:00:00	QQQ	ETF	28.3	28.37	28.19	28.37	2950.0
2008-11-19 05:00:00	QQQ	ETF	28.41	28.5	28.41	28.5	300.0
2008-11-19 06:00:00	QQQ	ETF	28.49	28.49	28.35	28.37	28000.0
2008-11-19 07:00:00	QQQ	ETF	28.39	28.53	28.31	28.32	732255.0
2008-11-19 08:00:00	QQQ	ETF	28.3	28.48	28.15	28.24	2843664.0
2008-11-19 09:00:00	QQQ	ETF	28.24	28.64	28.22	28.43	26737173.0
2008-11-19 10:00:00	QQQ	ETF	28.43	28.78	28.02	28.07	37277896.0
2008-11-19 11:00:00	QQQ	ETF	28.06	28.23	27.58	27.7	25140426.0
2008-11-19 12:00:00	QQQ	ETF	27.69	27.78	27.5	27.65	20227949.0
2008-11-19 13:00:00	QQQ	ETF	27.65	27.82	27.36	27.65	18608437.0
2008-11-19 14:00:00	QQQ	ETF	27.6501	27.8	27.26	27.71	33507701.0
2008-11-19 15:00:00	QQQ	ETF	27.71	27.8	26.79	26.82	63784273.0
2008-11-19 16:00:00	QQQ	ETF	26.82	28.4433	26.66	26.82	10753842.0
2008-11-19 17:00:00	QQQ	ETF	26.82	26.89	26.81	26.81	232145.0
2008-11-19 18:00:00	QQQ	ETF	26.8	26.86	26.79	26.84	83337.0
2008-11-19 19:00:00	QQQ	ETF	26.84	26.9	26.78	26.9	88577.0
2008-11-19 04:00:00	IWM	ETF	44.8	45.0	44.8	45.0	400.0
2008-11-19 05:00:00	IWM	ETF	45.02	45.27	45.02	45.27	500.0
2008-11-19 06:00:00	IWM	ETF	45.22	45.22	44.99	44.99	600.0
2008-11-19 07:00:00	IWM	ETF	44.94	45.16	44.87	44.87	50811.0
2008-11-19 08:00:00	IWM	ETF	44.8	45.31	44.48	44.5	415713.0
2008-11-19 09:00:00	IWM	ETF	44.53	45.15	44.3	44.53	8811857.0
2008-11-19 10:00:00	IWM	ETF	44.53	45.02	43.44	43.53	11868448.0
2008-11-19 11:00:00	IWM	ETF	43.53	43.8	42.8	43.11	10721913.0
2008-11-19 12:00:00	IWM	ETF	43.11	43.13	42.64	42.81	7869817.0
2008-11-19 13:00:00	IWM	ETF	42.8	43.15	42.44	42.97	7959441.0
2008-11-19 14:00:00	IWM	ETF	42.99	43.6	42.38	43.01	12924621.0
2008-11-19 15:00:00	IWM	ETF	43.02	44.25	41.24	41.38	29029375.0
2008-11-19 16:00:00	IWM	ETF	41.38	43.0	41.22	41.48	4700105.0
2008-11-19 17:00:00	IWM	ETF	41.42	41.5	41.37	41.45	19138.0
2008-11-19 18:00:00	IWM	ETF	41.4	41.45	41.26	41.26	9215.0
2008-11-19 19:00:00	IWM	ETF	41.34	41.55	41.34	41.55	2300.0
2008-11-19 04:00:00	DIA	ETF	84.1	84.1	84.1	84.1	100.0
2008-11-19 06:00:00	DIA	ETF	84.21	84.21	84.07	84.07	200.0

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

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