PREVIEW / etf_1hour / 2012-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-23.parquet
  size:    184 KB
  rows:    5,676

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
2012-01-23 04:00:00	SPY	ETF	131.16	131.32	131.08	131.08	7679.0
2012-01-23 05:00:00	SPY	ETF	131.21	131.48	131.21	131.4	20900.0
2012-01-23 06:00:00	SPY	ETF	131.65	131.8	131.59	131.61	107275.0
2012-01-23 07:00:00	SPY	ETF	131.63	131.72	131.57	131.64	267088.0
2012-01-23 08:00:00	SPY	ETF	131.67	131.74	131.1	131.5	1019054.0
2012-01-23 09:00:00	SPY	ETF	131.48	132.14	131.41	132.08	20164547.0
2012-01-23 10:00:00	SPY	ETF	132.07	132.25	131.86	131.949	16371500.0
2012-01-23 11:00:00	SPY	ETF	131.95	131.98	131.26	131.33	20601183.0
2012-01-23 12:00:00	SPY	ETF	131.33	131.35	130.98	131.16	15473291.0
2012-01-23 13:00:00	SPY	ETF	131.1598	131.51	131.15	131.49	9602747.0
2012-01-23 14:00:00	SPY	ETF	131.487	131.61	131.25	131.55	12564553.0
2012-01-23 15:00:00	SPY	ETF	131.56	131.825	131.45	131.6	22021374.0
2012-01-23 16:00:00	SPY	ETF	131.6	132.0748	131.32	131.45	9506960.0
2012-01-23 17:00:00	SPY	ETF	131.43	131.6196	131.43	131.47	231130.0
2012-01-23 18:00:00	SPY	ETF	131.47	131.57	131.44	131.55	68098.0
2012-01-23 19:00:00	SPY	ETF	131.55	131.56	131.45	131.47	71101.0
2012-01-23 04:00:00	QQQ	ETF	59.41	59.66	59.41	59.62	2317.0
2012-01-23 05:00:00	QQQ	ETF	59.75	59.85	59.75	59.81	1525.0
2012-01-23 06:00:00	QQQ	ETF	59.88	59.93	59.86	59.86	4100.0
2012-01-23 07:00:00	QQQ	ETF	59.85	59.9	59.84	59.86	13915.0
2012-01-23 08:00:00	QQQ	ETF	59.87	59.91	59.79	59.79	113367.0
2012-01-23 09:00:00	QQQ	ETF	59.79	60.1	59.73	60.05	4857548.0
2012-01-23 10:00:00	QQQ	ETF	60.04	60.21	59.96	60.04	5427141.0
2012-01-23 11:00:00	QQQ	ETF	60.04	60.055	59.62	59.63	5169156.0
2012-01-23 12:00:00	QQQ	ETF	59.63	59.65	59.44	59.5801	3692050.0
2012-01-23 13:00:00	QQQ	ETF	59.58	59.78	59.57	59.7701	6239807.0
2012-01-23 14:00:00	QQQ	ETF	59.77	59.79	59.59	59.74	3245357.0
2012-01-23 15:00:00	QQQ	ETF	59.745	59.835	59.7	59.77	4770973.0
2012-01-23 16:00:00	QQQ	ETF	59.77	59.83	59.7399	59.76	4413562.0
2012-01-23 17:00:00	QQQ	ETF	59.75	59.8	59.75	59.75	35473.0
2012-01-23 18:00:00	QQQ	ETF	59.78	59.82	59.77	59.82	1800.0
2012-01-23 19:00:00	QQQ	ETF	59.81	59.81	59.77	59.79	6345.0
2012-01-23 07:00:00	IWM	ETF	78.41	78.47	78.41	78.44	96500.0
2012-01-23 08:00:00	IWM	ETF	78.44	78.48	78.17	78.18	84306.0
2012-01-23 09:00:00	IWM	ETF	78.19	78.76	78.12	78.74	5760889.0
2012-01-23 10:00:00	IWM	ETF	78.73	78.84	78.46	78.52	4975841.0
2012-01-23 11:00:00	IWM	ETF	78.52	78.58	77.85	77.88	4994363.0
2012-01-23 12:00:00	IWM	ETF	77.88	77.93	77.55	77.8	3742625.0
2012-01-23 13:00:00	IWM	ETF	77.804	78.15	77.8	78.11	2885091.0
2012-01-23 14:00:00	IWM	ETF	78.11	78.14	77.8	78.08	2838508.0
2012-01-23 15:00:00	IWM	ETF	78.08	78.27	78.005	78.16	5325106.0
2012-01-23 16:00:00	IWM	ETF	78.16	78.7	78.03	78.13	2523124.0
2012-01-23 17:00:00	IWM	ETF	78.13	78.15	78.13	78.15	4740.0
2012-01-23 19:00:00	IWM	ETF	78.14	78.14	78.14	78.14	1015.0
2012-01-23 05:00:00	DIA	ETF	126.9	126.9	126.9	126.9	900.0
2012-01-23 08:00:00	DIA	ETF	127.0	127.23	126.86	126.88	14290.0
2012-01-23 09:00:00	DIA	ETF	126.92	127.28	126.79	127.26	868754.0
2012-01-23 10:00:00	DIA	ETF	127.26	127.36	127.02	127.11	841350.0
2012-01-23 11:00:00	DIA	ETF	127.1	127.12	126.61	126.63	876013.0
2012-01-23 12:00:00	DIA	ETF	126.64	126.66	126.38	126.46	682466.0

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

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