PREVIEW / etf_1hour / 2010-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-01.parquet
  size:    158 KB
  rows:    4,900

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-04-01 04:00:00	SPY	ETF	117.58	117.63	117.56	117.63	3550.0
2010-04-01 05:00:00	SPY	ETF	117.53	117.55	117.51	117.51	2509.0
2010-04-01 06:00:00	SPY	ETF	117.52	117.54	117.42	117.45	55900.0
2010-04-01 07:00:00	SPY	ETF	117.48	117.58	117.45	117.51	516219.0
2010-04-01 08:00:00	SPY	ETF	117.51	117.79	116.99	117.69	2265243.0
2010-04-01 09:00:00	SPY	ETF	117.69	118.19	117.0	118.04	23430660.0
2010-04-01 10:00:00	SPY	ETF	118.05	118.25	117.75	117.838	25103147.0
2010-04-01 11:00:00	SPY	ETF	117.83	118.03	117.71	117.93	13202179.0
2010-04-01 12:00:00	SPY	ETF	117.9378	117.96	117.8	117.85	9299080.0
2010-04-01 13:00:00	SPY	ETF	117.842	117.94	117.47	117.54	12592816.0
2010-04-01 14:00:00	SPY	ETF	117.55	117.64	117.1	117.41	28368598.0
2010-04-01 15:00:00	SPY	ETF	117.41	117.85	117.31	117.81	23206403.0
2010-04-01 16:00:00	SPY	ETF	117.81	117.94	117.29	117.84	18627179.0
2010-04-01 17:00:00	SPY	ETF	117.84	117.96	117.82	117.94	166289.0
2010-04-01 18:00:00	SPY	ETF	117.93	117.94	117.82	117.86	44136.0
2010-04-01 19:00:00	SPY	ETF	117.86	117.89	117.75	117.79	89516.0
2010-04-01 05:00:00	QQQ	ETF	48.21	48.23	48.21	48.23	4100.0
2010-04-01 06:00:00	QQQ	ETF	48.24	48.24	48.23	48.23	4500.0
2010-04-01 07:00:00	QQQ	ETF	48.27	48.3	48.25	48.29	68479.0
2010-04-01 08:00:00	QQQ	ETF	48.29	48.41	48.27	48.34	938253.0
2010-04-01 09:00:00	QQQ	ETF	48.34	48.66	48.16	48.6	8743104.0
2010-04-01 10:00:00	QQQ	ETF	48.61	48.7	48.36	48.395	11523342.0
2010-04-01 11:00:00	QQQ	ETF	48.39	48.4	48.26	48.35	8392879.0
2010-04-01 12:00:00	QQQ	ETF	48.36	48.38	48.27	48.319	4729506.0
2010-04-01 13:00:00	QQQ	ETF	48.32	48.32	47.99	48.02	8277912.0
2010-04-01 14:00:00	QQQ	ETF	48.03	48.08	47.79	47.98	19253987.0
2010-04-01 15:00:00	QQQ	ETF	47.97	48.18	47.94	48.17	14444625.0
2010-04-01 16:00:00	QQQ	ETF	48.16	48.3644	48.0129	48.12	3977887.0
2010-04-01 17:00:00	QQQ	ETF	48.12	48.16	48.12	48.14	40375.0
2010-04-01 18:00:00	QQQ	ETF	48.15	48.17	48.14	48.15	19413.0
2010-04-01 19:00:00	QQQ	ETF	48.16	48.17	48.12	48.13	35272.0
2010-04-01 04:00:00	IWM	ETF	68.23	68.23	68.23	68.23	1710.0
2010-04-01 06:00:00	IWM	ETF	68.25	68.27	68.25	68.26	900.0
2010-04-01 07:00:00	IWM	ETF	68.22	68.27	68.22	68.23	15100.0
2010-04-01 08:00:00	IWM	ETF	68.19	68.41	67.8	68.33	577493.0
2010-04-01 09:00:00	IWM	ETF	68.33	68.69	68.26	68.53	10348546.0
2010-04-01 10:00:00	IWM	ETF	68.532	68.65	68.31	68.4	8570333.0
2010-04-01 11:00:00	IWM	ETF	68.39	68.48	68.27	68.44	3917661.0
2010-04-01 12:00:00	IWM	ETF	68.435	68.47	68.25	68.3	2914395.0
2010-04-01 13:00:00	IWM	ETF	68.3	68.3	67.95	68.02	5163503.0
2010-04-01 14:00:00	IWM	ETF	68.01	68.14	67.73	68.01	8506518.0
2010-04-01 15:00:00	IWM	ETF	68.01	68.42	67.39	68.41	8865625.0
2010-04-01 16:00:00	IWM	ETF	68.41	68.4979	67.846	68.42	6071652.0
2010-04-01 17:00:00	IWM	ETF	68.43	68.48	68.41	68.47	163889.0
2010-04-01 18:00:00	IWM	ETF	68.47	68.47	68.39	68.4	16911.0
2010-04-01 19:00:00	IWM	ETF	68.47	68.5	68.4	68.4	5500.0
2010-04-01 07:00:00	DIA	ETF	109.1	109.1	109.08	109.08	1000.0
2010-04-01 08:00:00	DIA	ETF	109.08	109.27	109.05	109.21	25771.0
2010-04-01 09:00:00	DIA	ETF	109.25	109.49	109.2	109.41	2379293.0
2010-04-01 10:00:00	DIA	ETF	109.41	109.58	109.17	109.23	2015124.0

> showing 50 of 4,900 rows — these rows as CSV

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