PREVIEW / etf_1hour / 2009-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-19.parquet
  size:    142 KB
  rows:    4,320

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
2009-08-19 04:00:00	SPY	ETF	98.41	98.46	98.41	98.44	7717.0
2009-08-19 05:00:00	SPY	ETF	98.43	98.44	98.32	98.33	11092.0
2009-08-19 06:00:00	SPY	ETF	98.41	98.44	98.3	98.42	23800.0
2009-08-19 07:00:00	SPY	ETF	98.4	98.69	98.4	98.49	1080234.0
2009-08-19 08:00:00	SPY	ETF	98.49	98.51	98.16	98.38	4129379.0
2009-08-19 09:00:00	SPY	ETF	98.38	98.96	98.25	98.81	26560572.0
2009-08-19 10:00:00	SPY	ETF	98.81	99.31	98.81	99.02	33182105.0
2009-08-19 11:00:00	SPY	ETF	99.02	99.81	98.95	99.78	20530370.0
2009-08-19 12:00:00	SPY	ETF	99.77	100.18	99.7	100.055	26796176.0
2009-08-19 13:00:00	SPY	ETF	100.05	100.3	100.04	100.175	17079866.0
2009-08-19 14:00:00	SPY	ETF	100.1701	100.22	99.87	100.04	16187924.0
2009-08-19 15:00:00	SPY	ETF	100.0403	100.0499	99.61	100.0	33577828.0
2009-08-19 16:00:00	SPY	ETF	99.99	100.2	98.47	100.06	11261611.0
2009-08-19 17:00:00	SPY	ETF	100.07	100.24	99.2817	100.17	1362402.0
2009-08-19 18:00:00	SPY	ETF	100.15	100.15	100.01	100.11	342890.0
2009-08-19 19:00:00	SPY	ETF	100.11	100.15	100.07	100.09	147083.0
2009-08-19 04:00:00	QQQ	ETF	38.64	38.66	38.63	38.64	15940.0
2009-08-19 05:00:00	QQQ	ETF	38.62	38.63	38.6	38.6	16192.0
2009-08-19 06:00:00	QQQ	ETF	38.61	38.61	38.57	38.59	134950.0
2009-08-19 07:00:00	QQQ	ETF	38.6	38.71	38.6	38.62	887052.0
2009-08-19 08:00:00	QQQ	ETF	38.62	39.35	38.53	38.61	1445301.0
2009-08-19 09:00:00	QQQ	ETF	38.61	38.94	38.54	38.8498	15159036.0
2009-08-19 10:00:00	QQQ	ETF	38.85	39.07	38.84	38.89	14275649.0
2009-08-19 11:00:00	QQQ	ETF	38.9	39.18	38.85	39.17	9280153.0
2009-08-19 12:00:00	QQQ	ETF	39.17	39.35	39.15	39.29	10494900.0
2009-08-19 13:00:00	QQQ	ETF	39.29	39.38	39.28	39.38	6887064.0
2009-08-19 14:00:00	QQQ	ETF	39.3706	39.4	39.22	39.32	7527521.0
2009-08-19 15:00:00	QQQ	ETF	39.32	39.325	39.16	39.3	14254694.0
2009-08-19 16:00:00	QQQ	ETF	39.3	39.37	39.03	39.31	3091244.0
2009-08-19 17:00:00	QQQ	ETF	39.32	39.4	39.32	39.35	135197.0
2009-08-19 18:00:00	QQQ	ETF	39.34	39.38	39.34	39.35	152709.0
2009-08-19 19:00:00	QQQ	ETF	39.36	39.37	39.35	39.37	40781.0
2009-08-19 04:00:00	IWM	ETF	55.41	55.41	55.41	55.41	2000.0
2009-08-19 05:00:00	IWM	ETF	55.12	55.12	55.12	55.12	2000.0
2009-08-19 06:00:00	IWM	ETF	55.07	55.07	55.04	55.04	300.0
2009-08-19 07:00:00	IWM	ETF	55.21	55.31	55.2	55.2	119546.0
2009-08-19 08:00:00	IWM	ETF	55.2	55.2	54.92	55.05	662148.0
2009-08-19 09:00:00	IWM	ETF	55.05	55.54	54.82	55.35	5491216.0
2009-08-19 10:00:00	IWM	ETF	55.35	55.73	55.34	55.55	6018858.0
2009-08-19 11:00:00	IWM	ETF	55.55	56.0	55.45	55.97	3025005.0
2009-08-19 12:00:00	IWM	ETF	55.97	56.27	55.97	56.16	5041816.0
2009-08-19 13:00:00	IWM	ETF	56.15	56.27	56.09	56.21	2622633.0
2009-08-19 14:00:00	IWM	ETF	56.22	56.24	56.01	56.18	2659924.0
2009-08-19 15:00:00	IWM	ETF	56.18	56.21	55.88	56.2	7871524.0
2009-08-19 16:00:00	IWM	ETF	56.2	56.28	56.14	56.22	1130488.0
2009-08-19 17:00:00	IWM	ETF	56.22	56.29	56.22	56.29	107330.0
2009-08-19 18:00:00	IWM	ETF	56.28	56.39	56.27	56.35	16786.0
2009-08-19 19:00:00	IWM	ETF	56.32	56.38	56.31	56.31	4179.0
2009-08-19 07:00:00	DIA	ETF	91.81	91.92	91.79	91.79	8000.0
2009-08-19 08:00:00	DIA	ETF	91.81	91.82	91.56	91.74	163775.0

> showing 50 of 4,320 rows — these rows as CSV

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