PREVIEW / etf_1hour / 2012-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-30.parquet
  size:    179 KB
  rows:    5,602

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-08-30 04:00:00	SPY	ETF	141.02	141.11	140.96	140.97	9500.0
2012-08-30 05:00:00	SPY	ETF	141.08	141.08	141.0	141.0	612.0
2012-08-30 06:00:00	SPY	ETF	140.99	140.99	140.82	140.83	84862.0
2012-08-30 07:00:00	SPY	ETF	140.82	140.91	140.8	140.84	213239.0
2012-08-30 08:00:00	SPY	ETF	140.84	141.03	140.79	140.8	794546.0
2012-08-30 09:00:00	SPY	ETF	140.8	140.94	140.64	140.72	12731891.0
2012-08-30 10:00:00	SPY	ETF	140.72	140.83	140.19	140.39	21798817.0
2012-08-30 11:00:00	SPY	ETF	140.38	140.64	140.35	140.49	13740545.0
2012-08-30 12:00:00	SPY	ETF	140.5	140.6	140.36	140.58	8219190.0
2012-08-30 13:00:00	SPY	ETF	140.57	140.6	140.37	140.55	4635905.0
2012-08-30 14:00:00	SPY	ETF	140.56	140.71	140.52	140.699	6612888.0
2012-08-30 15:00:00	SPY	ETF	140.7	140.89	140.44	140.47	19895738.0
2012-08-30 16:00:00	SPY	ETF	140.48	140.5602	140.22	140.3	7479235.0
2012-08-30 17:00:00	SPY	ETF	140.3	140.35	140.26	140.28	49811.0
2012-08-30 18:00:00	SPY	ETF	140.31	140.34	140.23	140.23	80541.0
2012-08-30 19:00:00	SPY	ETF	140.26	140.3	140.22	140.29	40352.0
2012-08-30 04:00:00	QQQ	ETF	68.18	68.2	68.18	68.2	300.0
2012-08-30 06:00:00	QQQ	ETF	68.19	68.19	68.07	68.07	1200.0
2012-08-30 07:00:00	QQQ	ETF	68.11	68.13	68.06	68.09	1850.0
2012-08-30 08:00:00	QQQ	ETF	68.08	68.35	68.04	68.1	104147.0
2012-08-30 09:00:00	QQQ	ETF	68.1	68.16	67.94	67.98	4697677.0
2012-08-30 10:00:00	QQQ	ETF	67.97	68.01	67.6	67.71	5284724.0
2012-08-30 11:00:00	QQQ	ETF	67.72	67.845	67.71	67.755	2851039.0
2012-08-30 12:00:00	QQQ	ETF	67.74	67.77	67.66	67.74	1011814.0
2012-08-30 13:00:00	QQQ	ETF	67.74	67.7484	67.61	67.735	1703775.0
2012-08-30 14:00:00	QQQ	ETF	67.74	67.85	67.72	67.84	2429506.0
2012-08-30 15:00:00	QQQ	ETF	67.84	67.92	67.66	67.7	4800171.0
2012-08-30 16:00:00	QQQ	ETF	67.7	67.74	67.64	67.66	721082.0
2012-08-30 17:00:00	QQQ	ETF	67.69	67.69	67.68	67.68	709.0
2012-08-30 18:00:00	QQQ	ETF	67.68	67.68	67.67	67.67	490.0
2012-08-30 19:00:00	QQQ	ETF	67.66	67.68	67.65	67.68	5269.0
2012-08-30 04:00:00	IWM	ETF	81.36	81.36	81.36	81.36	100.0
2012-08-30 05:00:00	IWM	ETF	81.25	81.25	81.25	81.25	300.0
2012-08-30 06:00:00	IWM	ETF	81.16	81.16	81.08	81.11	22600.0
2012-08-30 07:00:00	IWM	ETF	81.12	81.14	81.08	81.12	39202.0
2012-08-30 08:00:00	IWM	ETF	81.09	81.29	81.07	81.07	157889.0
2012-08-30 09:00:00	IWM	ETF	81.07	81.25	80.9185	81.04	3956337.0
2012-08-30 10:00:00	IWM	ETF	81.04	81.125	80.64	80.75	5842654.0
2012-08-30 11:00:00	IWM	ETF	80.745	80.95	80.69	80.795	2817683.0
2012-08-30 12:00:00	IWM	ETF	80.79	80.94	80.72	80.9067	1688574.0
2012-08-30 13:00:00	IWM	ETF	80.91	80.92	80.77	80.89	1342087.0
2012-08-30 14:00:00	IWM	ETF	80.88	81.02	80.85	80.91	1898934.0
2012-08-30 15:00:00	IWM	ETF	80.91	81.01	80.78	80.79	4569620.0
2012-08-30 16:00:00	IWM	ETF	80.79	80.8188	80.57	80.61	1095780.0
2012-08-30 17:00:00	IWM	ETF	80.63	80.63	80.5	80.56	25702.0
2012-08-30 18:00:00	IWM	ETF	80.63	80.63	80.6	80.61	383.0
2012-08-30 07:00:00	DIA	ETF	130.38	130.38	130.31	130.31	3000.0
2012-08-30 08:00:00	DIA	ETF	130.41	130.5	130.34	130.36	7440.0
2012-08-30 09:00:00	DIA	ETF	130.4	130.44	130.13	130.21	562159.0
2012-08-30 10:00:00	DIA	ETF	130.2	130.345	129.65	129.84	1423610.0

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

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