PREVIEW / etf_1hour / 2007-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-24.parquet
  size:    81 KB
  rows:    2,692

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-24 04:00:00	SPY	ETF	152.15	152.15	152.15	152.15	100.0
2007-05-24 06:00:00	SPY	ETF	152.27	152.27	152.27	152.27	5000.0
2007-05-24 07:00:00	SPY	ETF	152.27	152.41	152.26	152.32	350800.0
2007-05-24 08:00:00	SPY	ETF	152.24	152.64	152.24	152.54	3426200.0
2007-05-24 09:00:00	SPY	ETF	152.54	152.78	152.28	152.65	15397942.0
2007-05-24 10:00:00	SPY	ETF	152.65	153.21	151.9	152.04	36891441.0
2007-05-24 11:00:00	SPY	ETF	152.04	152.4588	151.54	151.98	32942603.0
2007-05-24 12:00:00	SPY	ETF	151.97	152.01	151.26	151.56	20461385.0
2007-05-24 13:00:00	SPY	ETF	151.56	151.79	151.24	151.7	14139047.0
2007-05-24 14:00:00	SPY	ETF	151.69	151.75	151.03	151.09	21896732.0
2007-05-24 15:00:00	SPY	ETF	151.1	151.78	150.74	151.01	34314357.0
2007-05-24 16:00:00	SPY	ETF	151.01	151.18	150.93	151.06	2355200.0
2007-05-24 17:00:00	SPY	ETF	151.06	151.09	150.98	151.02	1805200.0
2007-05-24 18:00:00	SPY	ETF	151.1	151.16	151.05	151.12	132200.0
2007-05-24 19:00:00	SPY	ETF	151.13	151.23	151.13	151.17	6200.0
2007-05-24 05:00:00	QQQ	ETF	46.79	46.79	46.79	46.79	500.0
2007-05-24 07:00:00	QQQ	ETF	46.76	46.83	46.76	46.79	64082.0
2007-05-24 08:00:00	QQQ	ETF	46.79	46.93	46.76	46.89	957676.0
2007-05-24 09:00:00	QQQ	ETF	46.89	46.91	46.6	46.82	21138261.0
2007-05-24 10:00:00	QQQ	ETF	46.83	47.04	46.51	46.54	43384745.0
2007-05-24 11:00:00	QQQ	ETF	46.54	46.617	46.23	46.49	45195204.0
2007-05-24 12:00:00	QQQ	ETF	46.49	46.53	46.17	46.31	25192053.0
2007-05-24 13:00:00	QQQ	ETF	46.32	46.45	46.22	46.36	16075863.0
2007-05-24 14:00:00	QQQ	ETF	46.36	46.4	46.09	46.15	15772014.0
2007-05-24 15:00:00	QQQ	ETF	46.1505	46.21	45.97	46.12	27983612.0
2007-05-24 16:00:00	QQQ	ETF	46.12	46.25	45.98	46.14	1993695.0
2007-05-24 17:00:00	QQQ	ETF	46.16	46.17	46.14	46.14	1224242.0
2007-05-24 18:00:00	QQQ	ETF	46.16	46.18	46.15	46.15	9123.0
2007-05-24 19:00:00	QQQ	ETF	46.17	46.19	46.16	46.16	59086.0
2007-05-24 07:00:00	IWM	ETF	82.98	82.98	82.98	82.98	500.0
2007-05-24 08:00:00	IWM	ETF	82.91	83.08	82.84	83.04	401900.0
2007-05-24 09:00:00	IWM	ETF	83.04	83.22	82.79	83.15	6129469.0
2007-05-24 10:00:00	IWM	ETF	83.15	83.56	82.59	82.64	15797699.0
2007-05-24 11:00:00	IWM	ETF	82.65	82.82	82.03	82.35	19519227.0
2007-05-24 12:00:00	IWM	ETF	82.34	82.38	81.75	82.02	13125601.0
2007-05-24 13:00:00	IWM	ETF	82.02	82.27	81.84	82.24	6672867.0
2007-05-24 14:00:00	IWM	ETF	82.23	82.3	81.73	81.86	9496399.0
2007-05-24 15:00:00	IWM	ETF	81.85	82.0	81.56	81.83	14152944.0
2007-05-24 16:00:00	IWM	ETF	81.84	82.05	81.73	82.05	525200.0
2007-05-24 17:00:00	IWM	ETF	81.96	82.0	81.93	81.95	795100.0
2007-05-24 18:00:00	IWM	ETF	81.95	81.99	81.92	81.99	3900.0
2007-05-24 07:00:00	DIA	ETF	135.12	135.2	135.12	135.2	107100.0
2007-05-24 08:00:00	DIA	ETF	135.07	135.35	135.03	135.3	131400.0
2007-05-24 09:00:00	DIA	ETF	135.3	135.52	135.12	135.49	1872500.0
2007-05-24 10:00:00	DIA	ETF	135.49	136.33	135.03	135.18	6666450.0
2007-05-24 11:00:00	DIA	ETF	135.18	135.39	134.78	135.18	3031152.0
2007-05-24 12:00:00	DIA	ETF	135.18	135.2	134.51	134.82	3439500.0
2007-05-24 13:00:00	DIA	ETF	134.81	135.0	134.67	134.97	1454800.0
2007-05-24 14:00:00	DIA	ETF	134.97	135.04	134.32	134.36	3140200.0
2007-05-24 15:00:00	DIA	ETF	134.36	134.51	134.15	134.3	5392150.0

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

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