PREVIEW / etf_1hour / 2008-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-10.parquet
  size:    108 KB
  rows:    3,451

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-06-10 04:00:00	SPY	ETF	135.72	135.72	135.25	135.32	4200.0
2008-06-10 05:00:00	SPY	ETF	135.57	135.9	135.57	135.85	131100.0
2008-06-10 06:00:00	SPY	ETF	135.85	136.02	135.61	135.79	793719.0
2008-06-10 07:00:00	SPY	ETF	135.84	135.95	135.45	135.6	1694430.0
2008-06-10 08:00:00	SPY	ETF	135.6	135.69	135.18	135.52	5566399.0
2008-06-10 09:00:00	SPY	ETF	135.51	136.08	135.27	135.78	34228240.0
2008-06-10 10:00:00	SPY	ETF	135.78	136.51	135.65	136.07	41860745.0
2008-06-10 11:00:00	SPY	ETF	136.08	136.68	135.72	136.22	42045247.0
2008-06-10 12:00:00	SPY	ETF	136.22	136.82	135.99	136.61	27853916.0
2008-06-10 13:00:00	SPY	ETF	136.61	137.1	136.43	136.5	27037220.0
2008-06-10 14:00:00	SPY	ETF	136.5	136.57	135.81	136.38	35223617.0
2008-06-10 15:00:00	SPY	ETF	136.38	136.66	136.11	136.14	29975623.0
2008-06-10 16:00:00	SPY	ETF	136.14	136.561	135.89	135.94	10051132.0
2008-06-10 17:00:00	SPY	ETF	135.94	136.02	135.94	135.94	70176.0
2008-06-10 18:00:00	SPY	ETF	135.93	135.95	135.76	135.95	64219.0
2008-06-10 19:00:00	SPY	ETF	135.95	136.04	135.94	136.04	5000.0
2008-06-10 05:00:00	QQQ	ETF	48.45	48.53	48.45	48.52	2300.0
2008-06-10 06:00:00	QQQ	ETF	48.48	48.53	48.43	48.43	106600.0
2008-06-10 07:00:00	QQQ	ETF	48.5	48.59	48.4	48.42	675533.0
2008-06-10 08:00:00	QQQ	ETF	48.44	48.45	48.16	48.2	4552062.0
2008-06-10 09:00:00	QQQ	ETF	48.19	48.4799	48.12	48.39	20727824.0
2008-06-10 10:00:00	QQQ	ETF	48.39	48.6	48.22	48.44	28173107.0
2008-06-10 11:00:00	QQQ	ETF	48.43	48.57	48.24	48.4	23820418.0
2008-06-10 12:00:00	QQQ	ETF	48.41	48.81	48.33	48.7	19622786.0
2008-06-10 13:00:00	QQQ	ETF	48.7	48.94	48.59	48.69	18128725.0
2008-06-10 14:00:00	QQQ	ETF	48.69	48.7	48.37	48.52	21024948.0
2008-06-10 15:00:00	QQQ	ETF	48.525	48.71	48.51	48.54	16714989.0
2008-06-10 16:00:00	QQQ	ETF	48.55	48.57	48.46	48.53	3402546.0
2008-06-10 17:00:00	QQQ	ETF	48.53	48.56	48.52	48.56	12361.0
2008-06-10 18:00:00	QQQ	ETF	48.54	48.54	48.48	48.53	87440.0
2008-06-10 19:00:00	QQQ	ETF	48.5	48.55	48.5	48.55	3680.0
2008-06-10 06:00:00	IWM	ETF	73.06	73.11	73.06	73.11	5500.0
2008-06-10 07:00:00	IWM	ETF	73.12	73.24	72.95	73.12	109247.0
2008-06-10 08:00:00	IWM	ETF	73.04	73.09	72.8	72.92	575473.0
2008-06-10 09:00:00	IWM	ETF	72.86	73.15	72.75	72.95	16878822.0
2008-06-10 10:00:00	IWM	ETF	72.95	73.45	72.84	73.23	15489540.0
2008-06-10 11:00:00	IWM	ETF	73.23	73.41	72.25	72.96	14887399.0
2008-06-10 12:00:00	IWM	ETF	72.97	73.43	72.87	73.34	9565816.0
2008-06-10 13:00:00	IWM	ETF	73.33	73.63	73.2	73.23	10524040.0
2008-06-10 14:00:00	IWM	ETF	73.23	73.3	72.73	73.27	14148109.0
2008-06-10 15:00:00	IWM	ETF	73.27	73.44	73.06	73.13	12781105.0
2008-06-10 16:00:00	IWM	ETF	73.15	73.27	72.92	72.97	2025070.0
2008-06-10 17:00:00	IWM	ETF	72.92	73.01	72.92	73.01	2140.0
2008-06-10 18:00:00	IWM	ETF	72.9	72.9	72.9	72.9	1500.0
2008-06-10 19:00:00	IWM	ETF	73.0	73.0	72.89	72.99	943.0
2008-06-10 07:00:00	DIA	ETF	122.29	122.33	122.17	122.21	4100.0
2008-06-10 08:00:00	DIA	ETF	122.22	122.35	121.95	122.21	116024.0
2008-06-10 09:00:00	DIA	ETF	122.15	122.85	122.01	122.64	2019652.0
2008-06-10 10:00:00	DIA	ETF	122.65	123.16	122.5	122.87	2151673.0
2008-06-10 11:00:00	DIA	ETF	122.87	123.4	122.55	123.08	2117330.0

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

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