PREVIEW / etf_30min / 2011-12-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-23.parquet
  size:    266 KB
  rows:    9,111

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-23 04:00:00	SPY	ETF	125.7	125.72	125.65	125.72	52150.0
2011-12-23 04:30:00	SPY	ETF	125.74	125.77	125.7	125.77	3200.0
2011-12-23 05:00:00	SPY	ETF	125.85	125.85	125.79	125.82	800.0
2011-12-23 05:30:00	SPY	ETF	125.82	125.84	125.76	125.82	1470.0
2011-12-23 06:00:00	SPY	ETF	125.82	125.89	125.82	125.82	10700.0
2011-12-23 06:30:00	SPY	ETF	125.88	125.97	125.88	125.89	42231.0
2011-12-23 07:00:00	SPY	ETF	125.89	126.07	125.89	125.96	123735.0
2011-12-23 07:30:00	SPY	ETF	125.99	126.04	125.96	126.0	123995.0
2011-12-23 08:00:00	SPY	ETF	125.99	126.07	125.92	126.04	219145.0
2011-12-23 08:30:00	SPY	ETF	126.05	126.13	125.7	125.78	1465665.0
2011-12-23 09:00:00	SPY	ETF	125.78	125.9	125.67	125.69	1073332.0
2011-12-23 09:30:00	SPY	ETF	125.67	125.79	125.41	125.66	12548163.0
2011-12-23 10:00:00	SPY	ETF	125.66	125.8	125.55	125.67	7997278.0
2011-12-23 10:30:00	SPY	ETF	125.68	125.75	125.61	125.73	5318133.0
2011-12-23 11:00:00	SPY	ETF	125.72	125.94	125.71	125.925	5028431.0
2011-12-23 11:30:00	SPY	ETF	125.93	126.06	125.93	126.04	4088987.0
2011-12-23 12:00:00	SPY	ETF	126.05	126.15	125.97	126.1101	2579610.0
2011-12-23 12:30:00	SPY	ETF	126.11	126.25	126.11	126.1899	2983470.0
2011-12-23 13:00:00	SPY	ETF	126.19	126.2	126.03	126.0816	2888162.0
2011-12-23 13:30:00	SPY	ETF	126.09	126.12	126.02	126.1	2202349.0
2011-12-23 14:00:00	SPY	ETF	126.11	126.11	126.02	126.02	4451226.0
2011-12-23 14:30:00	SPY	ETF	126.02	126.09	126.01	126.05	2463768.0
2011-12-23 15:00:00	SPY	ETF	126.05	126.08	125.98	126.01	8257688.0
2011-12-23 15:30:00	SPY	ETF	126.0	126.43	126.0	126.38	14091411.0
2011-12-23 16:00:00	SPY	ETF	126.38	126.51	125.2588	126.46	12381975.0
2011-12-23 16:30:00	SPY	ETF	126.46	126.56	126.44	126.51	201828.0
2011-12-23 17:00:00	SPY	ETF	126.51	126.63	126.48	126.59	107819.0
2011-12-23 17:30:00	SPY	ETF	126.57	126.62	126.56	126.6	28144.0
2011-12-23 18:00:00	SPY	ETF	126.61	126.62	126.39	126.6	332165.0
2011-12-23 18:30:00	SPY	ETF	126.58	126.6	126.53	126.6	24238.0
2011-12-23 19:00:00	SPY	ETF	126.59	126.59	126.57	126.59	5410.0
2011-12-23 19:30:00	SPY	ETF	126.6	126.62	126.59	126.59	25266.0
2011-12-23 04:30:00	QQQ	ETF	55.7	55.7	55.69	55.69	12100.0
2011-12-23 05:00:00	QQQ	ETF	55.69	55.7	55.69	55.7	4600.0
2011-12-23 07:00:00	QQQ	ETF	55.78	55.78	55.75	55.78	1300.0
2011-12-23 07:30:00	QQQ	ETF	55.76	55.79	55.74	55.79	9600.0
2011-12-23 08:00:00	QQQ	ETF	55.78	55.82	55.74	55.79	176979.0
2011-12-23 08:30:00	QQQ	ETF	55.85	55.86	55.68	55.69	126560.0
2011-12-23 09:00:00	QQQ	ETF	55.7	55.73	55.68	55.68	137488.0
2011-12-23 09:30:00	QQQ	ETF	55.68	55.8	55.655	55.771	2656687.0
2011-12-23 10:00:00	QQQ	ETF	55.78	55.81	55.581	55.66	1986492.0
2011-12-23 10:30:00	QQQ	ETF	55.66	55.7	55.62	55.6999	792069.0
2011-12-23 11:00:00	QQQ	ETF	55.698	55.82	55.68	55.81	1772207.0
2011-12-23 11:30:00	QQQ	ETF	55.81	55.88	55.81	55.88	1818062.0
2011-12-23 12:00:00	QQQ	ETF	55.87	55.95	55.85	55.95	1444211.0
2011-12-23 12:30:00	QQQ	ETF	55.945	56.01	55.94	56.0	1157105.0
2011-12-23 13:00:00	QQQ	ETF	56.01	56.01	55.92	55.955	1303274.0
2011-12-23 13:30:00	QQQ	ETF	55.96	56.0	55.94	55.995	603342.0
2011-12-23 14:00:00	QQQ	ETF	55.995	56.0	55.92	55.93	467607.0
2011-12-23 14:30:00	QQQ	ETF	55.92	55.95	55.91	55.93	1138362.0

> showing 50 of 9,111 rows — these rows as CSV

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