PREVIEW / etf_1hour / 2011-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-13.parquet
  size:    182 KB
  rows:    5,622

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-13 04:00:00	SPY	ETF	124.21	124.7	124.0	124.7	58645.0
2011-12-13 05:00:00	SPY	ETF	124.74	124.8	124.62	124.75	4624.0
2011-12-13 06:00:00	SPY	ETF	124.74	125.05	124.74	124.92	56225.0
2011-12-13 07:00:00	SPY	ETF	124.87	125.02	124.56	124.98	397686.0
2011-12-13 08:00:00	SPY	ETF	124.98	125.01	124.56	124.86	3802041.0
2011-12-13 09:00:00	SPY	ETF	124.87	125.52	124.75	125.34	22719838.0
2011-12-13 10:00:00	SPY	ETF	125.33	125.57	124.495	124.65	35166851.0
2011-12-13 11:00:00	SPY	ETF	124.65	125.42	124.24	124.85	25687247.0
2011-12-13 12:00:00	SPY	ETF	124.85	125.51	124.47	124.8	12746035.0
2011-12-13 13:00:00	SPY	ETF	124.79	125.5689	124.54	124.78	11436920.0
2011-12-13 14:00:00	SPY	ETF	124.7846	125.5	123.59	123.87	40618492.0
2011-12-13 15:00:00	SPY	ETF	123.87	125.435	122.45	123.09	74031590.0
2011-12-13 16:00:00	SPY	ETF	123.09	124.6127	122.926	123.25	15765224.0
2011-12-13 17:00:00	SPY	ETF	123.25	123.27	123.19	123.24	333689.0
2011-12-13 18:00:00	SPY	ETF	123.24	123.37	123.11	123.23	594651.0
2011-12-13 19:00:00	SPY	ETF	123.23	123.44	123.22	123.35	266926.0
2011-12-13 04:00:00	QQQ	ETF	56.38	56.45	56.38	56.45	1400.0
2011-12-13 05:00:00	QQQ	ETF	56.62	56.65	56.61	56.65	2749.0
2011-12-13 06:00:00	QQQ	ETF	56.69	56.76	56.68	56.68	20750.0
2011-12-13 07:00:00	QQQ	ETF	56.69	56.82	56.66	56.78	101755.0
2011-12-13 08:00:00	QQQ	ETF	56.7	56.84	56.67	56.77	2381560.0
2011-12-13 09:00:00	QQQ	ETF	56.77	56.98	56.72	56.78	7636254.0
2011-12-13 10:00:00	QQQ	ETF	56.79	56.91	56.36	56.37	8342848.0
2011-12-13 11:00:00	QQQ	ETF	56.37	56.47	56.17	56.45	7742903.0
2011-12-13 12:00:00	QQQ	ETF	56.46	56.48	56.301	56.45	3466735.0
2011-12-13 13:00:00	QQQ	ETF	56.44	56.48	56.32	56.45	3053819.0
2011-12-13 14:00:00	QQQ	ETF	56.46	56.65	55.99	56.09	9772005.0
2011-12-13 15:00:00	QQQ	ETF	56.09	56.2	55.53	55.76	18053687.0
2011-12-13 16:00:00	QQQ	ETF	55.77	55.88	55.725	55.85	1138370.0
2011-12-13 17:00:00	QQQ	ETF	55.85	55.86	55.81	55.86	50100.0
2011-12-13 18:00:00	QQQ	ETF	55.85	55.94	55.82	55.85	31700.0
2011-12-13 19:00:00	QQQ	ETF	55.82	55.94	55.81	55.89	8020.0
2011-12-13 04:00:00	IWM	ETF	73.63	73.63	73.63	73.63	200.0
2011-12-13 05:00:00	IWM	ETF	73.96	73.97	73.96	73.97	200.0
2011-12-13 06:00:00	IWM	ETF	74.14	74.25	74.12	74.25	35538.0
2011-12-13 07:00:00	IWM	ETF	74.08	74.23	74.05	74.16	157446.0
2011-12-13 08:00:00	IWM	ETF	74.17	74.2	73.92	74.09	1221687.0
2011-12-13 09:00:00	IWM	ETF	74.06	74.47	73.37	74.19	5786419.0
2011-12-13 10:00:00	IWM	ETF	74.21	74.39	73.42	73.5	6494496.0
2011-12-13 11:00:00	IWM	ETF	73.5	73.89	73.11	73.86	6367506.0
2011-12-13 12:00:00	IWM	ETF	73.86	73.91	73.36	73.58	2455614.0
2011-12-13 13:00:00	IWM	ETF	73.5701	73.625	73.25	73.43	2533173.0
2011-12-13 14:00:00	IWM	ETF	73.44	73.79	72.62	72.87	8498438.0
2011-12-13 15:00:00	IWM	ETF	72.86	73.07	71.55	71.97	23683994.0
2011-12-13 16:00:00	IWM	ETF	71.98	72.1	71.86	72.05	5095374.0
2011-12-13 17:00:00	IWM	ETF	72.07	72.07	71.94	72.02	46742.0
2011-12-13 18:00:00	IWM	ETF	72.0	72.1	71.96	72.1	20379.0
2011-12-13 19:00:00	IWM	ETF	72.12	72.26	72.12	72.26	19050.0
2011-12-13 06:00:00	DIA	ETF	120.85	120.85	120.82	120.82	663.0
2011-12-13 07:00:00	DIA	ETF	120.82	120.82	120.82	120.82	200.0

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

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