PREVIEW / etf_1hour / 2010-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-22.parquet
  size:    169 KB
  rows:    5,270

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-22 05:00:00	SPY	ETF	125.4	125.44	125.4	125.44	12900.0
2010-12-22 06:00:00	SPY	ETF	125.4	125.4	125.4	125.4	200.0
2010-12-22 07:00:00	SPY	ETF	125.41	125.49	125.4	125.42	307413.0
2010-12-22 08:00:00	SPY	ETF	125.43	125.57	125.27	125.44	1118246.0
2010-12-22 09:00:00	SPY	ETF	125.44	125.56	125.25	125.52	9503565.0
2010-12-22 10:00:00	SPY	ETF	125.52	125.63	125.45	125.63	12395296.0
2010-12-22 11:00:00	SPY	ETF	125.63	125.71	125.57	125.675	8264773.0
2010-12-22 12:00:00	SPY	ETF	125.68	125.82	125.66	125.7716	6376270.0
2010-12-22 13:00:00	SPY	ETF	125.78	125.78	125.53	125.58	7973593.0
2010-12-22 14:00:00	SPY	ETF	125.5899	125.69	125.5862	125.68	6566117.0
2010-12-22 15:00:00	SPY	ETF	125.68	125.82	125.63	125.78	15688652.0
2010-12-22 16:00:00	SPY	ETF	125.77	125.84	125.595	125.78	7745989.0
2010-12-22 17:00:00	SPY	ETF	125.79	125.82	125.79	125.79	19600.0
2010-12-22 18:00:00	SPY	ETF	125.81	125.81	125.74	125.74	24635.0
2010-12-22 19:00:00	SPY	ETF	125.79	125.81	125.7	125.76	34019.0
2010-12-22 04:00:00	QQQ	ETF	54.81	54.81	54.81	54.81	200.0
2010-12-22 05:00:00	QQQ	ETF	54.86	54.86	54.86	54.86	200.0
2010-12-22 06:00:00	QQQ	ETF	54.86	54.86	54.86	54.86	200.0
2010-12-22 07:00:00	QQQ	ETF	54.85	54.87	54.83	54.87	32500.0
2010-12-22 08:00:00	QQQ	ETF	54.87	54.9	54.75	54.83	315579.0
2010-12-22 09:00:00	QQQ	ETF	54.83	54.92	54.8	54.84	4849789.0
2010-12-22 10:00:00	QQQ	ETF	54.84	54.87	54.79	54.86	4585910.0
2010-12-22 11:00:00	QQQ	ETF	54.86	54.95	54.845	54.9	4313040.0
2010-12-22 12:00:00	QQQ	ETF	54.9	54.96	54.84	54.8702	4285314.0
2010-12-22 13:00:00	QQQ	ETF	54.875	54.89	54.8	54.82	2637195.0
2010-12-22 14:00:00	QQQ	ETF	54.8119	54.88	54.81	54.87	1457905.0
2010-12-22 15:00:00	QQQ	ETF	54.87	54.94	54.85	54.882	6029611.0
2010-12-22 16:00:00	QQQ	ETF	54.88	54.97	54.825	54.9	3124489.0
2010-12-22 17:00:00	QQQ	ETF	54.91	54.92	54.9	54.92	16817.0
2010-12-22 18:00:00	QQQ	ETF	54.92	54.92	54.9	54.92	9700.0
2010-12-22 19:00:00	QQQ	ETF	54.93	54.93	54.9	54.92	5705.0
2010-12-22 04:00:00	IWM	ETF	79.0	79.04	79.0	79.04	200.0
2010-12-22 05:00:00	IWM	ETF	78.85	78.9	78.85	78.87	300.0
2010-12-22 06:00:00	IWM	ETF	78.9	78.9	78.9	78.9	800.0
2010-12-22 07:00:00	IWM	ETF	78.94	79.02	78.94	79.0	15161.0
2010-12-22 08:00:00	IWM	ETF	79.0	79.12	78.85	79.02	138909.0
2010-12-22 09:00:00	IWM	ETF	79.02	79.09	78.79	78.93	3514739.0
2010-12-22 10:00:00	IWM	ETF	78.94	79.03	78.72	78.87	6053829.0
2010-12-22 11:00:00	IWM	ETF	78.87	79.03	78.78	78.975	4037127.0
2010-12-22 12:00:00	IWM	ETF	78.98	79.18	78.95	79.03	3180159.0
2010-12-22 13:00:00	IWM	ETF	79.03	79.03	78.73	78.79	2531357.0
2010-12-22 14:00:00	IWM	ETF	78.79	78.95	78.78	78.9319	1546129.0
2010-12-22 15:00:00	IWM	ETF	78.93	78.99	78.8	78.81	4912147.0
2010-12-22 16:00:00	IWM	ETF	78.81	79.0	78.79	78.88	1659394.0
2010-12-22 17:00:00	IWM	ETF	78.9	78.9	78.9	78.9	100.0
2010-12-22 18:00:00	IWM	ETF	78.89	78.89	78.89	78.89	1126.0
2010-12-22 07:00:00	DIA	ETF	115.35	115.35	115.35	115.35	100.0
2010-12-22 08:00:00	DIA	ETF	115.3	115.34	115.29	115.34	2150.0
2010-12-22 09:00:00	DIA	ETF	115.34	115.4	115.25	115.33	482705.0
2010-12-22 10:00:00	DIA	ETF	115.32	115.42	115.27	115.42	705972.0

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

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