PREVIEW / etf_1hour / 2008-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-19.parquet
  size:    99 KB
  rows:    3,299

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-19 05:00:00	SPY	ETF	136.01	136.02	136.01	136.02	8500.0
2008-02-19 06:00:00	SPY	ETF	136.02	136.44	135.88	136.33	271900.0
2008-02-19 07:00:00	SPY	ETF	136.32	136.62	136.1	136.49	1135000.0
2008-02-19 08:00:00	SPY	ETF	136.51	136.99	134.7	136.67	5313700.0
2008-02-19 09:00:00	SPY	ETF	136.67	136.89	135.85	136.22	18394256.0
2008-02-19 10:00:00	SPY	ETF	136.22	136.55	135.76	135.98	20009320.0
2008-02-19 11:00:00	SPY	ETF	135.98	136.1	135.45	135.96	13697059.0
2008-02-19 12:00:00	SPY	ETF	135.97	136.22	135.73	135.748	11351805.0
2008-02-19 13:00:00	SPY	ETF	135.75	136.47	135.75	136.03	15994704.0
2008-02-19 14:00:00	SPY	ETF	136.03	136.32	134.93	134.96	20212766.0
2008-02-19 15:00:00	SPY	ETF	134.96	136.45	134.61	135.04	32069677.0
2008-02-19 16:00:00	SPY	ETF	135.02	135.68	135.0	135.4	2484800.0
2008-02-19 17:00:00	SPY	ETF	135.4	135.46	135.31	135.34	153300.0
2008-02-19 18:00:00	SPY	ETF	135.34	135.38	135.27	135.38	54800.0
2008-02-19 19:00:00	SPY	ETF	135.37	135.38	135.2	135.24	21200.0
2008-02-19 04:00:00	QQQ	ETF	44.23	44.25	44.23	44.25	1800.0
2008-02-19 05:00:00	QQQ	ETF	44.28	44.28	44.24	44.24	1790.0
2008-02-19 06:00:00	QQQ	ETF	44.25	44.4	44.25	44.4	8500.0
2008-02-19 07:00:00	QQQ	ETF	44.41	44.46	44.28	44.39	763222.0
2008-02-19 08:00:00	QQQ	ETF	44.39	44.6	44.36	44.39	2687831.0
2008-02-19 09:00:00	QQQ	ETF	44.38	44.5	44.1	44.1999	14844083.0
2008-02-19 10:00:00	QQQ	ETF	44.1905	44.28	44.04	44.1075	15750522.0
2008-02-19 11:00:00	QQQ	ETF	44.1099	44.14	43.97	44.13	8692695.0
2008-02-19 12:00:00	QQQ	ETF	44.13	44.26	44.03	44.05	10209568.0
2008-02-19 13:00:00	QQQ	ETF	44.05	44.29	43.99	44.02	10148477.0
2008-02-19 14:00:00	QQQ	ETF	44.02	44.04	43.42	43.42	17768073.0
2008-02-19 15:00:00	QQQ	ETF	43.43	43.51	43.27	43.45	19370511.0
2008-02-19 16:00:00	QQQ	ETF	43.45	43.8014	43.4	43.7	9977746.0
2008-02-19 17:00:00	QQQ	ETF	43.7	43.74	43.69	43.69	198796.0
2008-02-19 18:00:00	QQQ	ETF	43.72	44.47	43.69	43.71	34016.0
2008-02-19 19:00:00	QQQ	ETF	43.72	43.74	43.68	43.72	59948.0
2008-02-19 06:00:00	IWM	ETF	70.48	70.61	70.48	70.61	8500.0
2008-02-19 07:00:00	IWM	ETF	70.56	70.72	70.49	70.62	100900.0
2008-02-19 08:00:00	IWM	ETF	70.62	71.12	70.62	70.92	387100.0
2008-02-19 09:00:00	IWM	ETF	70.94	71.01	70.42	70.43	6755479.0
2008-02-19 10:00:00	IWM	ETF	70.44	70.54	70.04	70.21	7097630.0
2008-02-19 11:00:00	IWM	ETF	70.2	70.36	69.93	70.34	4101647.0
2008-02-19 12:00:00	IWM	ETF	70.35	70.52	70.15	70.21	4467875.0
2008-02-19 13:00:00	IWM	ETF	70.21	70.74	70.21	70.44	5540872.0
2008-02-19 14:00:00	IWM	ETF	70.44	70.7	69.72	69.73	6824611.0
2008-02-19 15:00:00	IWM	ETF	69.73	70.4	69.62	70.02	12226733.0
2008-02-19 16:00:00	IWM	ETF	70.03	70.73	69.98	70.3	2284600.0
2008-02-19 17:00:00	IWM	ETF	70.29	70.35	69.9	70.3	914800.0
2008-02-19 18:00:00	IWM	ETF	70.3	70.32	70.27	70.27	12500.0
2008-02-19 19:00:00	IWM	ETF	70.27	70.27	70.22	70.22	1300.0
2008-02-19 07:00:00	DIA	ETF	124.38	124.59	124.31	124.59	11400.0
2008-02-19 08:00:00	DIA	ETF	124.59	125.0	124.59	124.68	38300.0
2008-02-19 09:00:00	DIA	ETF	124.72	124.95	124.45	124.5	1577416.0
2008-02-19 10:00:00	DIA	ETF	124.51	124.69	124.04	124.22	1929626.0
2008-02-19 11:00:00	DIA	ETF	124.24	124.31	123.86	124.14	780600.0

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

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