PREVIEW / etf_1hour / 2010-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-16.parquet
  size:    172 KB
  rows:    5,257

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-16 04:00:00	SPY	ETF	124.39	124.47	124.34	124.34	1250.0
2010-12-16 05:00:00	SPY	ETF	124.28	124.28	124.18	124.18	700.0
2010-12-16 06:00:00	SPY	ETF	124.14	124.39	124.14	124.39	25100.0
2010-12-16 07:00:00	SPY	ETF	124.39	124.48	124.08	124.2	536590.0
2010-12-16 08:00:00	SPY	ETF	124.17	124.44	123.99	124.26	1024318.0
2010-12-16 09:00:00	SPY	ETF	124.25	124.36	123.75	123.77	14222545.0
2010-12-16 10:00:00	SPY	ETF	123.77	124.24	123.75	124.19	27584169.0
2010-12-16 11:00:00	SPY	ETF	124.19	124.7	124.15	124.65	28406205.0
2010-12-16 12:00:00	SPY	ETF	124.66	124.9	124.56	124.85	13267640.0
2010-12-16 13:00:00	SPY	ETF	124.86	124.91	124.69	124.805	13424375.0
2010-12-16 14:00:00	SPY	ETF	124.81	124.85	124.56	124.58	20681410.0
2010-12-16 15:00:00	SPY	ETF	124.59	124.83	124.54	124.79	30827339.0
2010-12-16 16:00:00	SPY	ETF	124.79	124.94	123.98	124.9	20279835.0
2010-12-16 17:00:00	SPY	ETF	124.93	124.94	124.8	124.87	1729360.0
2010-12-16 18:00:00	SPY	ETF	124.9	124.9	124.79	124.82	630153.0
2010-12-16 19:00:00	SPY	ETF	124.82	124.89	124.75	124.85	76514.0
2010-12-16 06:00:00	QQQ	ETF	54.26	54.26	54.26	54.26	200.0
2010-12-16 07:00:00	QQQ	ETF	54.28	54.3	54.16	54.19	44174.0
2010-12-16 08:00:00	QQQ	ETF	54.2	54.3	54.19	54.25	374267.0
2010-12-16 09:00:00	QQQ	ETF	54.24	54.35	54.06	54.12	6456212.0
2010-12-16 10:00:00	QQQ	ETF	54.11	54.37	54.07	54.34	9440389.0
2010-12-16 11:00:00	QQQ	ETF	54.35	54.64	54.31	54.59	7587697.0
2010-12-16 12:00:00	QQQ	ETF	54.581	54.66	54.54	54.64	2934360.0
2010-12-16 13:00:00	QQQ	ETF	54.64	54.65	54.55	54.56	3329392.0
2010-12-16 14:00:00	QQQ	ETF	54.5699	54.605	54.51	54.52	3166238.0
2010-12-16 15:00:00	QQQ	ETF	54.52	54.62	54.52	54.57	5728305.0
2010-12-16 16:00:00	QQQ	ETF	54.58	54.73	54.4307	54.67	5353249.0
2010-12-16 17:00:00	QQQ	ETF	54.67	54.68	54.61	54.61	205205.0
2010-12-16 18:00:00	QQQ	ETF	54.66	54.66	54.6	54.63	13287.0
2010-12-16 19:00:00	QQQ	ETF	54.6	54.65	54.6	54.65	19100.0
2010-12-16 04:00:00	IWM	ETF	77.32	77.32	77.32	77.32	100.0
2010-12-16 05:00:00	IWM	ETF	77.24	77.24	77.24	77.24	100.0
2010-12-16 06:00:00	IWM	ETF	77.12	77.12	77.12	77.12	100.0
2010-12-16 07:00:00	IWM	ETF	77.31	77.31	77.08	77.1	14995.0
2010-12-16 08:00:00	IWM	ETF	77.12	77.3	76.94	77.21	277363.0
2010-12-16 09:00:00	IWM	ETF	77.22	77.3	76.91	76.91	4340130.0
2010-12-16 10:00:00	IWM	ETF	76.92	77.28	76.86	77.18	7674086.0
2010-12-16 11:00:00	IWM	ETF	77.19	77.77	77.11	77.68	7963727.0
2010-12-16 12:00:00	IWM	ETF	77.69	77.97	77.62	77.835	5072439.0
2010-12-16 13:00:00	IWM	ETF	77.83	77.83	77.49	77.63	4843132.0
2010-12-16 14:00:00	IWM	ETF	77.63	77.68	77.43	77.58	3935734.0
2010-12-16 15:00:00	IWM	ETF	77.58	77.82	77.57	77.7915	11224368.0
2010-12-16 16:00:00	IWM	ETF	77.79	77.86	77.7	77.84	1537778.0
2010-12-16 17:00:00	IWM	ETF	77.82	77.91	77.82	77.91	14305.0
2010-12-16 18:00:00	IWM	ETF	77.77	77.9	77.77	77.9	10457.0
2010-12-16 19:00:00	IWM	ETF	77.85	77.85	77.85	77.85	1468.0
2010-12-16 07:00:00	DIA	ETF	115.23	115.23	114.97	114.99	4800.0
2010-12-16 08:00:00	DIA	ETF	115.0	115.1	115.0	115.05	5600.0
2010-12-16 09:00:00	DIA	ETF	115.02	115.08	114.42	114.42	1368558.0
2010-12-16 10:00:00	DIA	ETF	114.47	114.85	114.426	114.787	1575442.0

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

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