PREVIEW / etf_1hour / 2011-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-29.parquet
  size:    181 KB
  rows:    5,637

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-12-29 04:00:00	SPY	ETF	124.98	125.12	124.8	125.12	1341.0
2011-12-29 05:00:00	SPY	ETF	125.14	125.14	124.97	125.08	5900.0
2011-12-29 06:00:00	SPY	ETF	125.07	125.3	125.07	125.09	80450.0
2011-12-29 07:00:00	SPY	ETF	125.09	125.32	125.03	125.32	181340.0
2011-12-29 08:00:00	SPY	ETF	125.25	125.38	125.1	125.26	918506.0
2011-12-29 09:00:00	SPY	ETF	125.25	125.58	125.13	125.44	17256219.0
2011-12-29 10:00:00	SPY	ETF	125.4399	125.9	125.41	125.811	17767765.0
2011-12-29 11:00:00	SPY	ETF	125.8162	125.96	125.51	125.95	15291321.0
2011-12-29 12:00:00	SPY	ETF	125.9505	125.97	125.65	125.84	6632274.0
2011-12-29 13:00:00	SPY	ETF	125.84	125.99	125.72	125.88	9602588.0
2011-12-29 14:00:00	SPY	ETF	125.88	125.95	125.82	125.86	8760705.0
2011-12-29 15:00:00	SPY	ETF	125.86	126.25	125.86	126.16	26353016.0
2011-12-29 16:00:00	SPY	ETF	126.17	126.2	124.8567	126.08	16905095.0
2011-12-29 17:00:00	SPY	ETF	126.09	126.193	126.03	126.1	2017999.0
2011-12-29 18:00:00	SPY	ETF	126.08	126.17	126.05	126.1	396249.0
2011-12-29 19:00:00	SPY	ETF	126.1	126.16	126.03	126.08	78525.0
2011-12-29 04:00:00	QQQ	ETF	55.58	55.58	55.58	55.58	100.0
2011-12-29 06:00:00	QQQ	ETF	55.63	55.67	55.6	55.6	3800.0
2011-12-29 07:00:00	QQQ	ETF	55.61	55.66	55.58	55.66	14100.0
2011-12-29 08:00:00	QQQ	ETF	55.68	55.75	55.59	55.69	156687.0
2011-12-29 09:00:00	QQQ	ETF	55.69	55.75	55.51	55.56	2982323.0
2011-12-29 10:00:00	QQQ	ETF	55.56	55.8	55.5	55.75	4986324.0
2011-12-29 11:00:00	QQQ	ETF	55.76	55.91	55.67	55.905	4050861.0
2011-12-29 12:00:00	QQQ	ETF	55.91	55.92	55.81	55.9	2257944.0
2011-12-29 13:00:00	QQQ	ETF	55.9	55.98	55.86	55.91	2599199.0
2011-12-29 14:00:00	QQQ	ETF	55.92	55.96	55.87	55.9	1664016.0
2011-12-29 15:00:00	QQQ	ETF	55.8901	56.03	55.8901	55.98	4683858.0
2011-12-29 16:00:00	QQQ	ETF	55.98	56.02	55.91	55.97	1171935.0
2011-12-29 17:00:00	QQQ	ETF	55.98	56.02	55.98	56.0	5715.0
2011-12-29 18:00:00	QQQ	ETF	56.01	56.01	55.99	55.99	10705.0
2011-12-29 19:00:00	QQQ	ETF	56.0	56.01	55.98	56.01	12800.0
2011-12-29 08:00:00	IWM	ETF	73.88	73.88	73.6	73.7	288121.0
2011-12-29 09:00:00	IWM	ETF	73.66	74.01	73.6	73.95	3330663.0
2011-12-29 10:00:00	IWM	ETF	73.95	74.3	73.93	74.115	4156494.0
2011-12-29 11:00:00	IWM	ETF	74.13	74.3	73.98	74.28	2506803.0
2011-12-29 12:00:00	IWM	ETF	74.29	74.31	74.04	74.12	1624703.0
2011-12-29 13:00:00	IWM	ETF	74.13	74.2301	73.99	74.16	2727682.0
2011-12-29 14:00:00	IWM	ETF	74.16	74.22	74.11	74.14	1253380.0
2011-12-29 15:00:00	IWM	ETF	74.15	74.44	74.15	74.2	5623678.0
2011-12-29 16:00:00	IWM	ETF	74.2	74.29	74.09	74.25	1209618.0
2011-12-29 17:00:00	IWM	ETF	74.26	74.27	74.24	74.24	4600.0
2011-12-29 18:00:00	IWM	ETF	74.27	74.27	74.26	74.26	200.0
2011-12-29 19:00:00	IWM	ETF	74.27	74.28	74.21	74.24	5700.0
2011-12-29 08:00:00	DIA	ETF	121.53	121.67	121.38	121.49	369365.0
2011-12-29 09:00:00	DIA	ETF	121.49	122.0	121.46	121.95	599980.0
2011-12-29 10:00:00	DIA	ETF	121.96	122.26	121.93	122.17	624547.0
2011-12-29 11:00:00	DIA	ETF	122.2	122.38	121.91	122.3699	909088.0
2011-12-29 12:00:00	DIA	ETF	122.37	122.37	122.16	122.29	640800.0
2011-12-29 13:00:00	DIA	ETF	122.2998	122.4175	122.22	122.36	419502.0
2011-12-29 14:00:00	DIA	ETF	122.36	122.43	122.31	122.33	320116.0

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

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