PREVIEW / etf_1hour / 2008-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-27.parquet
  size:    105 KB
  rows:    3,348

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-05-27 06:00:00	SPY	ETF	137.69	137.69	137.45	137.55	28100.0
2008-05-27 07:00:00	SPY	ETF	137.48	137.55	137.32	137.51	359600.0
2008-05-27 08:00:00	SPY	ETF	137.5	137.95	137.39	137.62	1005257.0
2008-05-27 09:00:00	SPY	ETF	137.62	138.41	137.54	138.14	22274916.0
2008-05-27 10:00:00	SPY	ETF	138.13	138.66	137.89	138.35	27156499.0
2008-05-27 11:00:00	SPY	ETF	138.35	138.49	137.63	137.66	17883456.0
2008-05-27 12:00:00	SPY	ETF	137.66	138.1	137.53	138.06	14881283.0
2008-05-27 13:00:00	SPY	ETF	138.07	138.23	137.8	138.19	10458195.0
2008-05-27 14:00:00	SPY	ETF	138.195	138.82	138.06	138.73	22950048.0
2008-05-27 15:00:00	SPY	ETF	138.73	139.0	138.62	138.74	33253070.0
2008-05-27 16:00:00	SPY	ETF	138.74	138.82	137.82	138.76	10818732.0
2008-05-27 17:00:00	SPY	ETF	138.73	138.74	137.82	138.66	2545700.0
2008-05-27 18:00:00	SPY	ETF	138.73	138.75	138.73	138.73	3400.0
2008-05-27 19:00:00	SPY	ETF	138.7	138.76	138.68	138.74	12270.0
2008-05-27 07:00:00	QQQ	ETF	48.18	48.21	48.09	48.2	179050.0
2008-05-27 08:00:00	QQQ	ETF	48.19	48.27	48.13	48.26	463817.0
2008-05-27 09:00:00	QQQ	ETF	48.27	48.71	48.25	48.56	16535089.0
2008-05-27 10:00:00	QQQ	ETF	48.55	48.8	48.5	48.72	18643274.0
2008-05-27 11:00:00	QQQ	ETF	48.72	48.78	48.379	48.38	9700170.0
2008-05-27 12:00:00	QQQ	ETF	48.38	48.54	48.31	48.52	6549170.0
2008-05-27 13:00:00	QQQ	ETF	48.5299	48.7101	48.48	48.7	9833304.0
2008-05-27 14:00:00	QQQ	ETF	48.71	49.05	48.65	48.99	20488316.0
2008-05-27 15:00:00	QQQ	ETF	48.9899	49.11	48.95	49.079	16038291.0
2008-05-27 16:00:00	QQQ	ETF	49.07	49.1185	48.722	49.0	4014537.0
2008-05-27 17:00:00	QQQ	ETF	49.0	49.02	48.98	49.01	255264.0
2008-05-27 18:00:00	QQQ	ETF	49.02	49.03	49.0	49.01	17800.0
2008-05-27 19:00:00	QQQ	ETF	49.02	49.03	49.0	49.0	21400.0
2008-05-27 08:00:00	IWM	ETF	72.16	72.26	72.1	72.26	447839.0
2008-05-27 09:00:00	IWM	ETF	72.26	73.18	72.24	72.99	9609040.0
2008-05-27 10:00:00	IWM	ETF	72.98	73.42	72.92	73.05	10974166.0
2008-05-27 11:00:00	IWM	ETF	73.05	73.12	72.49	72.52	6635078.0
2008-05-27 12:00:00	IWM	ETF	72.52	72.83	72.43	72.78	4566982.0
2008-05-27 13:00:00	IWM	ETF	72.79	72.98	72.71	72.96	3191875.0
2008-05-27 14:00:00	IWM	ETF	72.96	73.31	72.87	73.21	6708128.0
2008-05-27 15:00:00	IWM	ETF	73.21	73.34	73.09	73.32	11496806.0
2008-05-27 16:00:00	IWM	ETF	73.32	73.35	72.3	73.19	5200100.0
2008-05-27 17:00:00	IWM	ETF	73.15	73.3	73.15	73.25	15268.0
2008-05-27 07:00:00	DIA	ETF	124.36	124.6	124.36	124.6	3103.0
2008-05-27 08:00:00	DIA	ETF	124.58	124.73	124.56	124.7	21364.0
2008-05-27 09:00:00	DIA	ETF	124.72	125.19	124.72	125.04	1041387.0
2008-05-27 10:00:00	DIA	ETF	125.03	125.5	124.89	125.17	1553877.0
2008-05-27 11:00:00	DIA	ETF	125.2	125.33	124.47	124.49	1163201.0
2008-05-27 12:00:00	DIA	ETF	124.49	124.99	124.37	124.98	654721.0
2008-05-27 13:00:00	DIA	ETF	124.99	125.07	124.77	125.03	780397.0
2008-05-27 14:00:00	DIA	ETF	125.04	125.55	124.93	125.49	1378124.0
2008-05-27 15:00:00	DIA	ETF	125.49	125.68	125.31	125.47	1657221.0
2008-05-27 16:00:00	DIA	ETF	125.47	125.55	125.43	125.5	1214657.0
2008-05-27 17:00:00	DIA	ETF	125.45	125.45	125.45	125.45	183.0
2008-05-27 18:00:00	DIA	ETF	125.5	125.5	125.5	125.5	100.0
2008-05-27 19:00:00	DIA	ETF	125.43	125.47	125.43	125.47	500.0

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

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