PREVIEW / etf_1hour / 2008-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-17.parquet
  size:    103 KB
  rows:    3,420

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-01-17 04:00:00	SPY	ETF	137.65	137.65	137.65	137.65	1000.0
2008-01-17 05:00:00	SPY	ETF	137.8	137.8	137.8	137.8	1000.0
2008-01-17 06:00:00	SPY	ETF	137.53	137.71	137.52	137.52	85000.0
2008-01-17 07:00:00	SPY	ETF	137.57	137.6	136.33	136.91	1621800.0
2008-01-17 08:00:00	SPY	ETF	136.94	137.96	136.44	137.89	15560900.0
2008-01-17 09:00:00	SPY	ETF	137.89	138.0	137.06	137.58	33619284.0
2008-01-17 10:00:00	SPY	ETF	137.57	137.58	135.29	135.97	78234795.0
2008-01-17 11:00:00	SPY	ETF	135.97	136.41	134.98	135.03	39056549.0
2008-01-17 12:00:00	SPY	ETF	135.03	137.0	134.5	135.1	40562416.0
2008-01-17 13:00:00	SPY	ETF	135.09	135.75	134.73	135.16	33407430.0
2008-01-17 14:00:00	SPY	ETF	135.16	135.29	133.95	134.59	50916773.0
2008-01-17 15:00:00	SPY	ETF	134.57	137.2162	132.93	133.23	78199717.0
2008-01-17 16:00:00	SPY	ETF	133.3	137.23	133.09	133.77	14278500.0
2008-01-17 17:00:00	SPY	ETF	133.77	133.85	133.64	133.66	2339700.0
2008-01-17 18:00:00	SPY	ETF	133.73	134.17	133.65	134.03	332300.0
2008-01-17 19:00:00	SPY	ETF	134.02	134.14	133.9	134.06	106900.0
2008-01-17 04:00:00	QQQ	ETF	46.28	46.28	46.28	46.28	200.0
2008-01-17 05:00:00	QQQ	ETF	46.3	46.33	46.3	46.33	300.0
2008-01-17 06:00:00	QQQ	ETF	46.3	46.33	46.29	46.29	44400.0
2008-01-17 07:00:00	QQQ	ETF	46.24	46.27	45.94	46.15	1160871.0
2008-01-17 08:00:00	QQQ	ETF	46.14	46.48	45.98	46.44	5703473.0
2008-01-17 09:00:00	QQQ	ETF	46.44	46.58	46.22	46.49	21405147.0
2008-01-17 10:00:00	QQQ	ETF	46.4805	46.49	45.63	45.99	61673071.0
2008-01-17 11:00:00	QQQ	ETF	45.99	46.24	45.73	45.76	23808133.0
2008-01-17 12:00:00	QQQ	ETF	45.75	46.03	45.49	45.84	30638350.0
2008-01-17 13:00:00	QQQ	ETF	45.83	46.17	45.65	45.88	24105447.0
2008-01-17 14:00:00	QQQ	ETF	45.9	45.96	45.46	45.68	28227234.0
2008-01-17 15:00:00	QQQ	ETF	45.69	45.84	45.2	45.37	45412508.0
2008-01-17 16:00:00	QQQ	ETF	45.36	46.23	45.25	45.63	11376204.0
2008-01-17 17:00:00	QQQ	ETF	45.64	46.0332	45.6	45.63	2756417.0
2008-01-17 18:00:00	QQQ	ETF	45.6	45.76	45.53	45.66	314138.0
2008-01-17 19:00:00	QQQ	ETF	45.68	45.73	45.63	45.69	52694.0
2008-01-17 07:00:00	IWM	ETF	69.99	69.99	69.36	69.63	307700.0
2008-01-17 08:00:00	IWM	ETF	69.62	70.12	69.31	70.08	1158100.0
2008-01-17 09:00:00	IWM	ETF	70.08	70.13	69.74	70.0	6746863.0
2008-01-17 10:00:00	IWM	ETF	69.98	69.99	68.41	69.01	29798840.0
2008-01-17 11:00:00	IWM	ETF	69.02	69.39	68.37	68.48	19189677.0
2008-01-17 12:00:00	IWM	ETF	68.48	68.61	68.03	68.42	13352736.0
2008-01-17 13:00:00	IWM	ETF	68.42	69.1	68.29	68.73	11627509.0
2008-01-17 14:00:00	IWM	ETF	68.73	68.8	67.87	68.31	17153508.0
2008-01-17 15:00:00	IWM	ETF	68.3	69.3	67.68	67.84	20386887.0
2008-01-17 16:00:00	IWM	ETF	67.85	68.13	67.72	68.09	4411318.0
2008-01-17 17:00:00	IWM	ETF	68.08	68.18	67.9	67.95	61500.0
2008-01-17 18:00:00	IWM	ETF	67.98	68.2	67.97	68.2	19000.0
2008-01-17 19:00:00	IWM	ETF	68.2	68.2	68.11	68.19	3300.0
2008-01-17 07:00:00	DIA	ETF	124.96	124.96	124.31	124.64	11900.0
2008-01-17 08:00:00	DIA	ETF	125.25	125.42	124.39	125.37	247500.0
2008-01-17 09:00:00	DIA	ETF	125.32	125.38	124.73	125.16	2208131.0
2008-01-17 10:00:00	DIA	ETF	125.12	125.14	123.46	123.87	6186838.0
2008-01-17 11:00:00	DIA	ETF	123.88	124.2	123.14	123.17	3050323.0

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

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