PREVIEW / etf_1hour / 2010-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-21.parquet
  size:    171 KB
  rows:    5,256

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-21 04:00:00	SPY	ETF	124.6	124.99	124.6	124.96	4800.0
2010-12-21 05:00:00	SPY	ETF	124.9	124.94	124.9	124.94	900.0
2010-12-21 06:00:00	SPY	ETF	124.85	124.91	124.85	124.87	20000.0
2010-12-21 07:00:00	SPY	ETF	124.87	124.95	124.85	124.92	607809.0
2010-12-21 08:00:00	SPY	ETF	124.92	125.08	124.89	125.02	1172675.0
2010-12-21 09:00:00	SPY	ETF	125.01	125.135	124.87	125.02	12850471.0
2010-12-21 10:00:00	SPY	ETF	125.02	125.21	124.96	125.15	15335629.0
2010-12-21 11:00:00	SPY	ETF	125.15	125.25	125.07	125.15	10656389.0
2010-12-21 12:00:00	SPY	ETF	125.16	125.35	125.15	125.33	6942097.0
2010-12-21 13:00:00	SPY	ETF	125.33	125.34	125.24	125.29	7267123.0
2010-12-21 14:00:00	SPY	ETF	125.28	125.311	125.24	125.29	6793190.0
2010-12-21 15:00:00	SPY	ETF	125.3	125.47	125.25	125.36	19227976.0
2010-12-21 16:00:00	SPY	ETF	125.36	125.44	124.8957	125.37	10515581.0
2010-12-21 17:00:00	SPY	ETF	125.36	125.37	124.5866	125.33	1611688.0
2010-12-21 18:00:00	SPY	ETF	125.35	125.4	125.28	125.29	105276.0
2010-12-21 19:00:00	SPY	ETF	125.29	125.35	125.29	125.35	20201.0
2010-12-21 04:00:00	QQQ	ETF	54.67	54.67	54.66	54.66	946.0
2010-12-21 05:00:00	QQQ	ETF	54.67	54.67	54.66	54.66	700.0
2010-12-21 07:00:00	QQQ	ETF	54.64	54.7	54.64	54.7	36600.0
2010-12-21 08:00:00	QQQ	ETF	54.69	54.75	54.69	54.71	151154.0
2010-12-21 09:00:00	QQQ	ETF	54.71	54.83	54.62	54.72	5218953.0
2010-12-21 10:00:00	QQQ	ETF	54.73	54.81	54.7	54.789	3800157.0
2010-12-21 11:00:00	QQQ	ETF	54.7875	54.82	54.75	54.77	2042138.0
2010-12-21 12:00:00	QQQ	ETF	54.78	54.88	54.77	54.87	1690360.0
2010-12-21 13:00:00	QQQ	ETF	54.87	54.8701	54.82	54.84	1705767.0
2010-12-21 14:00:00	QQQ	ETF	54.841	54.86	54.81	54.83	3117489.0
2010-12-21 15:00:00	QQQ	ETF	54.83	54.88	54.79	54.88	4935305.0
2010-12-21 16:00:00	QQQ	ETF	54.88	54.92	54.75	54.8	6363804.0
2010-12-21 17:00:00	QQQ	ETF	54.8	54.85	54.78	54.82	91193.0
2010-12-21 18:00:00	QQQ	ETF	54.81	54.81	54.79	54.79	29325.0
2010-12-21 19:00:00	QQQ	ETF	54.8	54.84	54.79	54.83	33685.0
2010-12-21 04:00:00	IWM	ETF	78.55	78.55	78.55	78.55	121.0
2010-12-21 06:00:00	IWM	ETF	78.62	78.62	78.61	78.61	4500.0
2010-12-21 07:00:00	IWM	ETF	78.63	78.67	78.61	78.67	28154.0
2010-12-21 08:00:00	IWM	ETF	78.65	78.79	78.64	78.75	455171.0
2010-12-21 09:00:00	IWM	ETF	78.75	78.85	78.59	78.7175	4064436.0
2010-12-21 10:00:00	IWM	ETF	78.71	78.88	78.6762	78.85	2483877.0
2010-12-21 11:00:00	IWM	ETF	78.85	79.04	78.84	79.013	3302461.0
2010-12-21 12:00:00	IWM	ETF	79.02	79.16	78.97	79.1499	3699020.0
2010-12-21 13:00:00	IWM	ETF	79.1498	79.2199	79.1	79.16	2482977.0
2010-12-21 14:00:00	IWM	ETF	79.16	79.28	79.13	79.23	3681122.0
2010-12-21 15:00:00	IWM	ETF	79.225	79.26	79.07	79.19	7273390.0
2010-12-21 16:00:00	IWM	ETF	79.19	79.25	78.935	79.22	1699660.0
2010-12-21 17:00:00	IWM	ETF	79.21	79.21	79.17	79.18	11500.0
2010-12-21 07:00:00	DIA	ETF	115.03	115.03	115.03	115.03	100.0
2010-12-21 08:00:00	DIA	ETF	114.99	115.19	114.99	115.12	14200.0
2010-12-21 09:00:00	DIA	ETF	115.13	115.1664	114.99	115.08	416876.0
2010-12-21 10:00:00	DIA	ETF	115.08	115.295	115.05	115.18	460662.0
2010-12-21 11:00:00	DIA	ETF	115.19	115.23	115.14	115.19	206193.0
2010-12-21 12:00:00	DIA	ETF	115.19	115.32	115.18	115.31	272179.0

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

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