PREVIEW / etf_1hour / 2010-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-29.parquet
  size:    166 KB
  rows:    5,143

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
2010-12-29 04:00:00	SPY	ETF	126.01	126.04	125.98	125.98	644.0
2010-12-29 05:00:00	SPY	ETF	126.0	126.02	125.94	126.02	12700.0
2010-12-29 06:00:00	SPY	ETF	126.02	126.02	125.93	125.93	24600.0
2010-12-29 07:00:00	SPY	ETF	125.93	125.96	125.86	125.88	170689.0
2010-12-29 08:00:00	SPY	ETF	125.89	125.98	125.83	125.97	340566.0
2010-12-29 09:00:00	SPY	ETF	125.97	126.05	125.9	126.01	5965220.0
2010-12-29 10:00:00	SPY	ETF	126.01	126.12	126.0	126.01	8857245.0
2010-12-29 11:00:00	SPY	ETF	126.01	126.07	125.96	126.02	6338482.0
2010-12-29 12:00:00	SPY	ETF	126.0262	126.15	126.0262	126.12	5606638.0
2010-12-29 13:00:00	SPY	ETF	126.11	126.19	126.11	126.155	4435193.0
2010-12-29 14:00:00	SPY	ETF	126.16	126.2	126.1	126.14	3477045.0
2010-12-29 15:00:00	SPY	ETF	126.14	126.19	125.91	125.93	13964274.0
2010-12-29 16:00:00	SPY	ETF	125.92	126.092	125.86	125.95	6436066.0
2010-12-29 17:00:00	SPY	ETF	125.95	126.0	125.9	125.94	56875.0
2010-12-29 18:00:00	SPY	ETF	125.96	126.0	125.92	125.99	32774.0
2010-12-29 19:00:00	SPY	ETF	125.99	126.0	125.91	125.97	30889.0
2010-12-29 04:00:00	QQQ	ETF	54.76	54.76	54.75	54.75	400.0
2010-12-29 06:00:00	QQQ	ETF	54.8	54.81	54.8	54.81	500.0
2010-12-29 07:00:00	QQQ	ETF	54.79	54.8	54.79	54.79	8300.0
2010-12-29 08:00:00	QQQ	ETF	54.77	54.81	54.75	54.8	86104.0
2010-12-29 09:00:00	QQQ	ETF	54.8	54.84	54.73	54.79	2508132.0
2010-12-29 10:00:00	QQQ	ETF	54.79	54.9	54.79	54.86	3380446.0
2010-12-29 11:00:00	QQQ	ETF	54.86	54.88	54.76	54.8	4899571.0
2010-12-29 12:00:00	QQQ	ETF	54.8	54.87	54.795	54.86	1196192.0
2010-12-29 13:00:00	QQQ	ETF	54.86	54.89	54.83	54.849	2173096.0
2010-12-29 14:00:00	QQQ	ETF	54.8475	54.88	54.82	54.84	1536335.0
2010-12-29 15:00:00	QQQ	ETF	54.8336	54.88	54.77	54.78	4064429.0
2010-12-29 16:00:00	QQQ	ETF	54.78	54.8052	54.68	54.77	877613.0
2010-12-29 17:00:00	QQQ	ETF	54.74	54.77	54.74	54.74	5000.0
2010-12-29 18:00:00	QQQ	ETF	54.78	54.78	54.77	54.77	35200.0
2010-12-29 19:00:00	QQQ	ETF	54.77	54.78	54.76	54.76	73743.0
2010-12-29 06:00:00	IWM	ETF	78.85	78.85	78.85	78.85	500.0
2010-12-29 07:00:00	IWM	ETF	78.81	78.81	78.78	78.79	7900.0
2010-12-29 08:00:00	IWM	ETF	78.78	78.85	78.76	78.84	22400.0
2010-12-29 09:00:00	IWM	ETF	78.82	78.96	78.75	78.94	2736261.0
2010-12-29 10:00:00	IWM	ETF	78.93	79.02	78.84	78.8677	2960181.0
2010-12-29 11:00:00	IWM	ETF	78.86	78.98	78.81	78.93	1419046.0
2010-12-29 12:00:00	IWM	ETF	78.93	78.96	78.84	78.94	1130512.0
2010-12-29 13:00:00	IWM	ETF	78.94	78.98	78.89	78.92	737785.0
2010-12-29 14:00:00	IWM	ETF	78.92	78.97	78.87	78.885	1032877.0
2010-12-29 15:00:00	IWM	ETF	78.89	79.0	78.82	78.89	4806785.0
2010-12-29 16:00:00	IWM	ETF	78.89	78.92	78.76	78.8	1125533.0
2010-12-29 17:00:00	IWM	ETF	78.84	78.84	78.82	78.83	2400.0
2010-12-29 19:00:00	IWM	ETF	78.83	78.86	78.82	78.82	500.0
2010-12-29 08:00:00	DIA	ETF	115.6	115.65	115.6	115.63	10335.0
2010-12-29 09:00:00	DIA	ETF	115.63	115.91	115.63	115.9	505499.0
2010-12-29 10:00:00	DIA	ETF	115.9	115.93	115.71	115.71	1797034.0
2010-12-29 11:00:00	DIA	ETF	115.71	115.77	115.69	115.74	1071655.0
2010-12-29 12:00:00	DIA	ETF	115.74	115.94	115.74	115.9	442356.0
2010-12-29 13:00:00	DIA	ETF	115.9	115.98	115.8985	115.93	313367.0

> showing 50 of 5,143 rows — these rows as CSV

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