PREVIEW / etf_1hour / 2012-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-01.parquet
  size:    189 KB
  rows:    5,858

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-10-01 04:00:00	SPY	ETF	144.3	144.66	144.3	144.66	29050.0
2012-10-01 05:00:00	SPY	ETF	144.7	144.7	144.61	144.61	900.0
2012-10-01 06:00:00	SPY	ETF	144.51	144.61	144.5	144.6	5050.0
2012-10-01 07:00:00	SPY	ETF	144.6	144.61	144.43	144.54	165960.0
2012-10-01 08:00:00	SPY	ETF	144.51	144.74	143.93	144.67	705917.0
2012-10-01 09:00:00	SPY	ETF	143.97	144.91	143.93	144.7	13591618.0
2012-10-01 10:00:00	SPY	ETF	144.71	145.69	144.71	145.34	24770076.0
2012-10-01 11:00:00	SPY	ETF	145.33	145.54	145.07	145.15	14735076.0
2012-10-01 12:00:00	SPY	ETF	145.15	145.33	144.71	144.89	14398242.0
2012-10-01 13:00:00	SPY	ETF	144.88	144.9	144.39	144.84	17217053.0
2012-10-01 14:00:00	SPY	ETF	144.84	144.96	144.64	144.8827	11563478.0
2012-10-01 15:00:00	SPY	ETF	144.88	144.89	144.02	144.33	25140625.0
2012-10-01 16:00:00	SPY	ETF	144.33	146.0	144.0082	144.26	6430738.0
2012-10-01 17:00:00	SPY	ETF	144.26	144.35	144.13	144.25	4744186.0
2012-10-01 18:00:00	SPY	ETF	144.27	144.35	144.26	144.31	28392.0
2012-10-01 19:00:00	SPY	ETF	144.31	144.34	144.22	144.3	33047.0
2012-10-01 04:00:00	QQQ	ETF	68.82	68.82	68.82	68.82	100.0
2012-10-01 05:00:00	QQQ	ETF	69.0	69.0	68.95	68.96	380.0
2012-10-01 06:00:00	QQQ	ETF	68.93	68.95	68.93	68.93	1300.0
2012-10-01 07:00:00	QQQ	ETF	68.97	68.97	68.9	68.94	63783.0
2012-10-01 08:00:00	QQQ	ETF	68.93	69.03	68.91	69.0	84600.0
2012-10-01 09:00:00	QQQ	ETF	68.98	69.06	68.8	68.84	3097010.0
2012-10-01 10:00:00	QQQ	ETF	68.84	69.33	68.84	69.04	6036390.0
2012-10-01 11:00:00	QQQ	ETF	69.035	69.175	68.91	68.94	3894736.0
2012-10-01 12:00:00	QQQ	ETF	68.94	68.98	68.6	68.7	3523175.0
2012-10-01 13:00:00	QQQ	ETF	68.7	68.75	68.37	68.73	5827815.0
2012-10-01 14:00:00	QQQ	ETF	68.725	68.77	68.59	68.73	3154738.0
2012-10-01 15:00:00	QQQ	ETF	68.72	68.73	68.25	68.48	6008805.0
2012-10-01 16:00:00	QQQ	ETF	68.48	68.6204	68.41	68.49	3789214.0
2012-10-01 17:00:00	QQQ	ETF	68.51	68.52	68.48	68.48	19347.0
2012-10-01 18:00:00	QQQ	ETF	68.5	68.54	68.5	68.54	14155.0
2012-10-01 19:00:00	QQQ	ETF	68.51	68.51	68.46	68.46	15700.0
2012-10-01 04:00:00	IWM	ETF	83.83	83.83	83.83	83.83	454.0
2012-10-01 05:00:00	IWM	ETF	84.12	84.12	84.12	84.12	216.0
2012-10-01 06:00:00	IWM	ETF	84.06	84.14	84.05	84.1	1724.0
2012-10-01 07:00:00	IWM	ETF	84.1	84.11	83.95	83.95	1756.0
2012-10-01 08:00:00	IWM	ETF	83.99	84.1	83.44	84.07	160867.0
2012-10-01 09:00:00	IWM	ETF	84.04	84.1	83.44	83.82	3686804.0
2012-10-01 10:00:00	IWM	ETF	83.83	84.54	83.83	84.17	8170971.0
2012-10-01 11:00:00	IWM	ETF	84.17	84.37	83.77	83.83	6314179.0
2012-10-01 12:00:00	IWM	ETF	83.83	83.92	83.51	83.59	4481437.0
2012-10-01 13:00:00	IWM	ETF	83.58	83.66	83.31	83.65	4548692.0
2012-10-01 14:00:00	IWM	ETF	83.65	84.04	83.59	83.99	3192921.0
2012-10-01 15:00:00	IWM	ETF	83.98	83.99	83.3901	83.71	6409540.0
2012-10-01 16:00:00	IWM	ETF	83.71	83.82	83.68	83.72	1050053.0
2012-10-01 17:00:00	IWM	ETF	83.76	83.78	83.71	83.71	6800.0
2012-10-01 19:00:00	IWM	ETF	83.77	83.78	83.74	83.75	5782.0
2012-10-01 07:00:00	DIA	ETF	134.5	134.5	134.5	134.5	205.0
2012-10-01 08:00:00	DIA	ETF	134.47	134.77	134.47	134.74	6290.0
2012-10-01 09:00:00	DIA	ETF	134.71	135.02	134.53	134.74	420716.0

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

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