PREVIEW / etf_1hour / 2011-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-26.parquet
  size:    177 KB
  rows:    5,432

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
2011-01-26 04:00:00	SPY	ETF	129.25	129.7	129.25	129.7	6600.0
2011-01-26 05:00:00	SPY	ETF	129.66	129.7	129.65	129.7	4100.0
2011-01-26 06:00:00	SPY	ETF	129.72	129.8	129.67	129.8	121022.0
2011-01-26 07:00:00	SPY	ETF	129.8	129.81	129.59	129.6	257435.0
2011-01-26 08:00:00	SPY	ETF	129.6	129.68	128.1863	129.48	782548.0
2011-01-26 09:00:00	SPY	ETF	129.47	129.54	129.23	129.39	13812173.0
2011-01-26 10:00:00	SPY	ETF	129.39	129.99	129.34	129.75	26473510.0
2011-01-26 11:00:00	SPY	ETF	129.755	129.93	129.44	129.595	12541928.0
2011-01-26 12:00:00	SPY	ETF	129.6	129.82	129.52	129.775	12030057.0
2011-01-26 13:00:00	SPY	ETF	129.77	129.94	129.68	129.81	9171827.0
2011-01-26 14:00:00	SPY	ETF	129.81	130.05	129.52	129.92	24496891.0
2011-01-26 15:00:00	SPY	ETF	129.925	130.05	129.67	129.67	26851409.0
2011-01-26 16:00:00	SPY	ETF	129.67	129.86	129.275	129.72	14274939.0
2011-01-26 17:00:00	SPY	ETF	129.71	129.72	129.65	129.69	210404.0
2011-01-26 18:00:00	SPY	ETF	129.67	129.69	129.6	129.66	129204.0
2011-01-26 19:00:00	SPY	ETF	129.67	129.79	129.67	129.77	40318.0
2011-01-26 04:00:00	QQQ	ETF	56.64	56.72	56.64	56.72	1874.0
2011-01-26 06:00:00	QQQ	ETF	56.69	56.78	56.69	56.77	2500.0
2011-01-26 07:00:00	QQQ	ETF	56.77	56.78	56.69	56.73	119200.0
2011-01-26 08:00:00	QQQ	ETF	56.7	56.71	56.51	56.68	163710.0
2011-01-26 09:00:00	QQQ	ETF	56.67	56.67	56.45	56.57	7858076.0
2011-01-26 10:00:00	QQQ	ETF	56.56	56.98	56.54	56.845	11211801.0
2011-01-26 11:00:00	QQQ	ETF	56.84	56.9	56.68	56.74	4866385.0
2011-01-26 12:00:00	QQQ	ETF	56.7401	56.88	56.73	56.86	3718101.0
2011-01-26 13:00:00	QQQ	ETF	56.855	56.95	56.79	56.9	4303687.0
2011-01-26 14:00:00	QQQ	ETF	56.89	56.95	56.74	56.91	7800430.0
2011-01-26 15:00:00	QQQ	ETF	56.9	56.98	56.8	56.8081	8331452.0
2011-01-26 16:00:00	QQQ	ETF	56.8	56.94	56.8	56.91	2523482.0
2011-01-26 17:00:00	QQQ	ETF	56.93	56.93	56.9	56.9	37835.0
2011-01-26 18:00:00	QQQ	ETF	56.91	56.93	56.89	56.92	76172.0
2011-01-26 19:00:00	QQQ	ETF	56.91	56.94	56.91	56.93	23957.0
2011-01-26 04:00:00	IWM	ETF	78.19	78.19	78.19	78.19	300.0
2011-01-26 05:00:00	IWM	ETF	78.31	78.31	78.31	78.31	300.0
2011-01-26 06:00:00	IWM	ETF	78.31	78.31	78.0	78.0	400.0
2011-01-26 07:00:00	IWM	ETF	78.37	78.43	78.28	78.31	140181.0
2011-01-26 08:00:00	IWM	ETF	78.28	78.32	77.9	78.19	283504.0
2011-01-26 09:00:00	IWM	ETF	78.18	78.19	77.75	77.9	4292280.0
2011-01-26 10:00:00	IWM	ETF	77.9	79.38	77.9	78.97	18065938.0
2011-01-26 11:00:00	IWM	ETF	78.97	79.12	78.6	78.89	5996573.0
2011-01-26 12:00:00	IWM	ETF	78.89	79.19	78.79	79.1781	2919913.0
2011-01-26 13:00:00	IWM	ETF	79.17	79.25	79.03	79.06	2859748.0
2011-01-26 14:00:00	IWM	ETF	79.06	79.29	78.88	79.1	9259798.0
2011-01-26 15:00:00	IWM	ETF	79.1	79.32	78.98	79.12	9843739.0
2011-01-26 16:00:00	IWM	ETF	79.12	79.231	79.09	79.12	4793423.0
2011-01-26 17:00:00	IWM	ETF	79.14	79.14	79.08	79.1	27400.0
2011-01-26 18:00:00	IWM	ETF	79.08	79.16	79.04	79.16	10500.0
2011-01-26 19:00:00	IWM	ETF	79.11	79.16	79.1	79.15	1400.0
2011-01-26 05:00:00	DIA	ETF	119.79	119.8	119.79	119.8	5000.0
2011-01-26 06:00:00	DIA	ETF	119.8	119.82	119.8	119.82	7500.0
2011-01-26 07:00:00	DIA	ETF	119.83	119.85	119.6	119.63	13949.0

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

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