PREVIEW / etf_1hour / 2007-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-27.parquet
  size:    93 KB
  rows:    3,094

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-07-27 04:00:00	SPY	ETF	148.4	148.84	148.2	148.72	28900.0
2007-07-27 05:00:00	SPY	ETF	148.75	148.75	148.4	148.4	7000.0
2007-07-27 06:00:00	SPY	ETF	148.17	148.48	147.99	148.08	114800.0
2007-07-27 07:00:00	SPY	ETF	148.1	148.1	146.92	147.07	6098700.0
2007-07-27 08:00:00	SPY	ETF	147.33	148.47	146.93	147.69	23543700.0
2007-07-27 09:00:00	SPY	ETF	147.65	148.4399	147.17	148.08	43883400.0
2007-07-27 10:00:00	SPY	ETF	148.08	148.87	146.57	147.53	65724295.0
2007-07-27 11:00:00	SPY	ETF	147.53	148.01	146.43	146.76	44405330.0
2007-07-27 12:00:00	SPY	ETF	146.76	147.2	146.12	146.77	55880610.0
2007-07-27 13:00:00	SPY	ETF	146.77	147.9	146.57	147.66	39168248.0
2007-07-27 14:00:00	SPY	ETF	147.67	148.14	146.86	147.84	38238580.0
2007-07-27 15:00:00	SPY	ETF	147.84	147.98	145.24	146.04	66002065.0
2007-07-27 16:00:00	SPY	ETF	145.8	146.7	144.95	145.36	27803300.0
2007-07-27 17:00:00	SPY	ETF	145.34	145.55	145.16	145.4	452400.0
2007-07-27 18:00:00	SPY	ETF	145.38	145.44	145.13	145.2	153100.0
2007-07-27 19:00:00	SPY	ETF	145.3	147.7105	145.13	145.25	37700.0
2007-07-27 07:00:00	QQQ	ETF	48.74	48.75	48.51	48.55	666462.0
2007-07-27 08:00:00	QQQ	ETF	48.57	48.93	48.54	48.79	4708295.0
2007-07-27 09:00:00	QQQ	ETF	48.78	48.95	48.49	48.86	31290629.0
2007-07-27 10:00:00	QQQ	ETF	48.8505	49.12	48.58	48.7294	46341018.0
2007-07-27 11:00:00	QQQ	ETF	48.73	48.9	48.43	48.49	28650915.0
2007-07-27 12:00:00	QQQ	ETF	48.5085	48.57	48.14	48.29	43388685.0
2007-07-27 13:00:00	QQQ	ETF	48.29	48.64	48.2574	48.56	26814114.0
2007-07-27 14:00:00	QQQ	ETF	48.56	48.79	48.35	48.65	23830207.0
2007-07-27 15:00:00	QQQ	ETF	48.65	48.7	48.08	48.09	30110701.0
2007-07-27 16:00:00	QQQ	ETF	48.09	48.48	47.84	47.93	4776124.0
2007-07-27 17:00:00	QQQ	ETF	47.94	48.08	47.93	48.04	164076.0
2007-07-27 18:00:00	QQQ	ETF	48.05	48.07	48.0	48.05	23473.0
2007-07-27 19:00:00	QQQ	ETF	48.05	48.6178	47.97	48.05	12432.0
2007-07-27 06:00:00	IWM	ETF	78.4	78.41	78.39	78.4	13000.0
2007-07-27 07:00:00	IWM	ETF	78.36	78.36	77.47	77.5	1073300.0
2007-07-27 08:00:00	IWM	ETF	77.5	78.4	77.45	78.17	4453000.0
2007-07-27 09:00:00	IWM	ETF	78.15	78.7	77.67	78.31	20668455.0
2007-07-27 10:00:00	IWM	ETF	78.32	79.2	78.07	78.26	36794719.0
2007-07-27 11:00:00	IWM	ETF	78.26	78.53	77.7	77.79	27749193.0
2007-07-27 12:00:00	IWM	ETF	77.79	77.92	77.25	77.59	27187870.0
2007-07-27 13:00:00	IWM	ETF	77.59	78.46	77.5	78.22	14099683.0
2007-07-27 14:00:00	IWM	ETF	78.22	78.54	77.56	78.28	22597817.0
2007-07-27 15:00:00	IWM	ETF	78.27	78.42	77.27	77.27	22929690.0
2007-07-27 16:00:00	IWM	ETF	77.27	78.7874	76.43	76.9	4642800.0
2007-07-27 17:00:00	IWM	ETF	76.9	76.93	76.84	76.93	75900.0
2007-07-27 18:00:00	IWM	ETF	76.8	76.93	76.8	76.93	300.0
2007-07-27 19:00:00	IWM	ETF	76.94	78.3	76.94	78.3	5600.0
2007-07-27 07:00:00	DIA	ETF	133.84	134.0	133.75	133.8	92900.0
2007-07-27 08:00:00	DIA	ETF	133.8	134.64	133.8	134.32	482500.0
2007-07-27 09:00:00	DIA	ETF	134.34	134.88	133.87	134.59	2796500.0
2007-07-27 10:00:00	DIA	ETF	134.57	135.1	133.82	134.02	5173600.0
2007-07-27 11:00:00	DIA	ETF	134.03	134.33	133.3	133.44	3660700.0
2007-07-27 12:00:00	DIA	ETF	133.44	133.69	132.91	133.48	8038600.0
2007-07-27 13:00:00	DIA	ETF	133.38	134.05	133.21	133.9	3300600.0

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

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