PREVIEW / etf_1hour / 2007-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-14.parquet
  size:    72 KB
  rows:    2,346

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
2007-05-14 04:00:00	SPY	ETF	151.01	151.01	151.01	151.01	100.0
2007-05-14 05:00:00	SPY	ETF	150.88	150.88	150.84	150.84	200.0
2007-05-14 06:00:00	SPY	ETF	150.87	150.87	150.74	150.82	15000.0
2007-05-14 07:00:00	SPY	ETF	150.84	150.84	150.72	150.77	237000.0
2007-05-14 08:00:00	SPY	ETF	150.77	150.94	150.76	150.93	823200.0
2007-05-14 09:00:00	SPY	ETF	150.93	151.3	150.83	151.12	9389660.0
2007-05-14 10:00:00	SPY	ETF	151.115	151.115	150.65	150.89	27533242.0
2007-05-14 11:00:00	SPY	ETF	150.88	150.89	150.66	150.78	10442435.0
2007-05-14 12:00:00	SPY	ETF	150.77	150.93	150.76	150.89	5991647.0
2007-05-14 13:00:00	SPY	ETF	150.89	150.9	150.32	150.36	17251921.0
2007-05-14 14:00:00	SPY	ETF	150.35	150.37	149.79	150.2	20339383.0
2007-05-14 15:00:00	SPY	ETF	150.2	150.55	150.16	150.55	13431013.0
2007-05-14 16:00:00	SPY	ETF	150.54	150.58	150.18	150.49	1768100.0
2007-05-14 17:00:00	SPY	ETF	150.45	150.45	150.33	150.35	17800.0
2007-05-14 18:00:00	SPY	ETF	150.38	150.4	150.37	150.38	18100.0
2007-05-14 19:00:00	SPY	ETF	150.39	150.4	150.37	150.37	2400.0
2007-05-14 07:00:00	QQQ	ETF	46.77	46.78	46.75	46.75	29700.0
2007-05-14 08:00:00	QQQ	ETF	46.76	46.88	46.75	46.84	2099757.0
2007-05-14 09:00:00	QQQ	ETF	46.84	46.88	46.77	46.79	9629433.0
2007-05-14 10:00:00	QQQ	ETF	46.79	46.79	46.53	46.64	26096897.0
2007-05-14 11:00:00	QQQ	ETF	46.64	46.65	46.5	46.56	10760886.0
2007-05-14 12:00:00	QQQ	ETF	46.55	46.62	46.51	46.58	4358022.0
2007-05-14 13:00:00	QQQ	ETF	46.58	46.58	46.33	46.34	16121242.0
2007-05-14 14:00:00	QQQ	ETF	46.33	46.35	46.19	46.28	19732265.0
2007-05-14 15:00:00	QQQ	ETF	46.28	46.45	46.27	46.45	20131693.0
2007-05-14 16:00:00	QQQ	ETF	46.45	46.46	46.37	46.39	4045611.0
2007-05-14 17:00:00	QQQ	ETF	46.39	46.41	46.35	46.39	53252.0
2007-05-14 18:00:00	QQQ	ETF	46.38	46.39	46.36	46.39	42698.0
2007-05-14 19:00:00	QQQ	ETF	46.39	46.39	46.35	46.36	22544.0
2007-05-14 07:00:00	IWM	ETF	82.25	82.25	82.25	82.25	200.0
2007-05-14 08:00:00	IWM	ETF	82.3	82.4	82.3	82.4	19800.0
2007-05-14 09:00:00	IWM	ETF	82.37	82.59	82.2	82.45	5898487.0
2007-05-14 10:00:00	IWM	ETF	82.44	82.45	81.97	82.23	11597972.0
2007-05-14 11:00:00	IWM	ETF	82.22	82.27	81.96	82.13	7522508.0
2007-05-14 12:00:00	IWM	ETF	82.13	82.22	82.07	82.11	2630395.0
2007-05-14 13:00:00	IWM	ETF	82.12	82.17	81.62	81.66	11411130.0
2007-05-14 14:00:00	IWM	ETF	81.65	81.85	81.46	81.55	15473330.0
2007-05-14 15:00:00	IWM	ETF	81.54	81.8	81.48	81.6	9130266.0
2007-05-14 16:00:00	IWM	ETF	81.6	81.75	81.55	81.56	848500.0
2007-05-14 17:00:00	IWM	ETF	81.52	81.55	81.41	81.41	186400.0
2007-05-14 18:00:00	IWM	ETF	81.41	81.47	81.41	81.44	66500.0
2007-05-14 07:00:00	DIA	ETF	133.45	133.48	133.41	133.41	6000.0
2007-05-14 08:00:00	DIA	ETF	133.49	133.63	133.48	133.58	15300.0
2007-05-14 09:00:00	DIA	ETF	133.6	133.95	133.57	133.84	1112400.0
2007-05-14 10:00:00	DIA	ETF	133.83	133.83	133.58	133.72	2042100.0
2007-05-14 11:00:00	DIA	ETF	133.71	133.72	133.51	133.69	675200.0
2007-05-14 12:00:00	DIA	ETF	133.69	133.85	133.69	133.82	431200.0
2007-05-14 13:00:00	DIA	ETF	133.82	133.84	133.34	133.39	1742860.0
2007-05-14 14:00:00	DIA	ETF	133.39	133.44	133.09	133.3	2922300.0
2007-05-14 15:00:00	DIA	ETF	133.29	133.65	133.26	133.65	1605600.0

> showing 50 of 2,346 rows — these rows as CSV

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