PREVIEW / etf_1hour / 2008-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-01.parquet
  size:    108 KB
  rows:    3,422

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-01 05:00:00	SPY	ETF	138.69	138.69	138.69	138.69	1000.0
2008-05-01 06:00:00	SPY	ETF	138.8	138.9	138.76	138.85	158300.0
2008-05-01 07:00:00	SPY	ETF	138.9	138.92	138.8	138.91	747631.0
2008-05-01 08:00:00	SPY	ETF	138.88	138.91	138.26	138.46	3274957.0
2008-05-01 09:00:00	SPY	ETF	138.46	138.95	138.27	138.75	16429289.0
2008-05-01 10:00:00	SPY	ETF	138.75	139.18	138.68	139.0999	31769416.0
2008-05-01 11:00:00	SPY	ETF	139.09	139.52	138.98	139.28	19479864.0
2008-05-01 12:00:00	SPY	ETF	139.29	140.61	139.28	140.45	26391873.0
2008-05-01 13:00:00	SPY	ETF	140.45	141.0	140.24	140.35	27792858.0
2008-05-01 14:00:00	SPY	ETF	140.35	141.0	140.24	140.622	25122886.0
2008-05-01 15:00:00	SPY	ETF	140.62	141.02	140.36	140.94	28600264.0
2008-05-01 16:00:00	SPY	ETF	140.9	141.17	140.7	141.05	2991639.0
2008-05-01 17:00:00	SPY	ETF	141.04	141.12	140.2424	141.04	279735.0
2008-05-01 18:00:00	SPY	ETF	141.05	141.12	141.0	141.12	20862.0
2008-05-01 19:00:00	SPY	ETF	141.12	141.14	141.06	141.13	14300.0
2008-05-01 06:00:00	QQQ	ETF	47.28	47.28	47.28	47.28	100.0
2008-05-01 07:00:00	QQQ	ETF	47.3	47.39	47.3	47.32	173443.0
2008-05-01 08:00:00	QQQ	ETF	47.32	47.38	47.21	47.28	1442148.0
2008-05-01 09:00:00	QQQ	ETF	47.29	47.65	47.15	47.61	15397963.0
2008-05-01 10:00:00	QQQ	ETF	47.61	48.01	47.61	48.01	24648839.0
2008-05-01 11:00:00	QQQ	ETF	48.01	48.24	47.985	48.12	17222403.0
2008-05-01 12:00:00	QQQ	ETF	48.12	48.52	48.12	48.44	16513745.0
2008-05-01 13:00:00	QQQ	ETF	48.44	48.55	48.31	48.36	13899013.0
2008-05-01 14:00:00	QQQ	ETF	48.3525	48.58	48.3	48.45	17030279.0
2008-05-01 15:00:00	QQQ	ETF	48.441	48.72	48.36	48.69	19258871.0
2008-05-01 16:00:00	QQQ	ETF	48.682	48.73	48.5192	48.69	8931065.0
2008-05-01 17:00:00	QQQ	ETF	48.68	48.7	48.66	48.68	2093894.0
2008-05-01 18:00:00	QQQ	ETF	48.68	48.69	48.66	48.68	47613.0
2008-05-01 19:00:00	QQQ	ETF	48.68	48.7	48.67	48.69	34196.0
2008-05-01 06:00:00	IWM	ETF	71.73	71.74	71.69	71.69	10300.0
2008-05-01 07:00:00	IWM	ETF	71.68	71.68	71.66	71.68	12700.0
2008-05-01 08:00:00	IWM	ETF	71.66	71.66	71.39	71.47	449160.0
2008-05-01 09:00:00	IWM	ETF	71.46	71.89	71.23	71.67	5010567.0
2008-05-01 10:00:00	IWM	ETF	71.67	72.06	71.67	71.91	7872195.0
2008-05-01 11:00:00	IWM	ETF	71.9	72.17	71.83	71.98	4301384.0
2008-05-01 12:00:00	IWM	ETF	71.99	72.86	71.99	72.78	7289624.0
2008-05-01 13:00:00	IWM	ETF	72.78	72.83	72.55	72.59	6619582.0
2008-05-01 14:00:00	IWM	ETF	72.6	72.81	72.46	72.62	6483912.0
2008-05-01 15:00:00	IWM	ETF	72.63	72.81	72.52	72.69	7224936.0
2008-05-01 16:00:00	IWM	ETF	72.67	72.84	71.45	72.72	8875861.0
2008-05-01 17:00:00	IWM	ETF	72.71	72.82	72.71	72.82	5605.0
2008-05-01 06:00:00	DIA	ETF	128.31	128.31	128.31	128.31	100.0
2008-05-01 07:00:00	DIA	ETF	128.47	128.47	128.36	128.36	10600.0
2008-05-01 08:00:00	DIA	ETF	128.42	128.42	128.03	128.03	48440.0
2008-05-01 09:00:00	DIA	ETF	128.04	128.36	127.84	128.2	1680688.0
2008-05-01 10:00:00	DIA	ETF	128.21	128.53	128.11	128.46	2397658.0
2008-05-01 11:00:00	DIA	ETF	128.44	128.83	128.37	128.67	1897365.0
2008-05-01 12:00:00	DIA	ETF	128.67	129.8	128.67	129.74	2569260.0
2008-05-01 13:00:00	DIA	ETF	129.72	130.17	129.59	129.68	2895854.0
2008-05-01 14:00:00	DIA	ETF	129.69	130.18	129.55	129.82	3191616.0

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

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