PREVIEW / etf_30min / 2011-08-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-09.parquet
  size:    340 KB
  rows:    11,110

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-08-09 04:00:00	SPY	ETF	111.6	113.09	111.6	112.5	16630.0
2011-08-09 04:30:00	SPY	ETF	112.25	112.27	110.66	111.77	49293.0
2011-08-09 05:00:00	SPY	ETF	111.6	111.6	110.21	110.35	26429.0
2011-08-09 05:30:00	SPY	ETF	110.57	112.22	110.5	111.86	119970.0
2011-08-09 06:00:00	SPY	ETF	111.84	112.19	111.66	112.14	91100.0
2011-08-09 06:30:00	SPY	ETF	112.15	113.09	111.9	113.03	733756.0
2011-08-09 07:00:00	SPY	ETF	113.03	114.17	112.9	113.51	3194238.0
2011-08-09 07:30:00	SPY	ETF	113.48	113.79	112.57	113.48	2834621.0
2011-08-09 08:00:00	SPY	ETF	113.44	114.5	112.83	112.91	5159620.0
2011-08-09 08:30:00	SPY	ETF	112.92	113.78	112.26	113.18	5783358.0
2011-08-09 09:00:00	SPY	ETF	113.18	114.22	112.82	114.07	6822418.0
2011-08-09 09:30:00	SPY	ETF	114.07	114.31	112.14	114.14	69327824.0
2011-08-09 10:00:00	SPY	ETF	114.14	114.99	114.05	114.96	55159240.0
2011-08-09 10:30:00	SPY	ETF	114.96	115.3	114.54	114.89	38442441.0
2011-08-09 11:00:00	SPY	ETF	114.9	114.99	113.94	114.96	35039027.0
2011-08-09 11:30:00	SPY	ETF	114.98	115.37	114.58	115.22	19074083.0
2011-08-09 12:00:00	SPY	ETF	115.23	115.46	115.03	115.14	19117606.0
2011-08-09 12:30:00	SPY	ETF	115.145	115.37	114.62	114.6201	13651642.0
2011-08-09 13:00:00	SPY	ETF	114.62	114.91	114.35	114.59	14208717.0
2011-08-09 13:30:00	SPY	ETF	114.59	114.71	113.51	113.93	23736511.0
2011-08-09 14:00:00	SPY	ETF	113.93	114.93	111.775	113.43	80363127.0
2011-08-09 14:30:00	SPY	ETF	113.43	114.02	110.27	111.895	97250587.0
2011-08-09 15:00:00	SPY	ETF	111.89	114.71	111.28	114.4899	64868616.0
2011-08-09 15:30:00	SPY	ETF	114.48	117.5	113.85	117.47	75033736.0
2011-08-09 16:00:00	SPY	ETF	117.46	118.02	114.2075	117.57	31153348.0
2011-08-09 16:30:00	SPY	ETF	117.59	117.86	112.1405	117.82	24071209.0
2011-08-09 17:00:00	SPY	ETF	117.82	118.43	111.09	118.39	11411719.0
2011-08-09 17:30:00	SPY	ETF	118.34	118.39	118.16	118.22	252376.0
2011-08-09 18:00:00	SPY	ETF	118.24	118.38	117.37	118.3	456217.0
2011-08-09 18:30:00	SPY	ETF	118.3	118.36	117.4474	118.31	15087305.0
2011-08-09 19:00:00	SPY	ETF	118.33	118.33	118.12	118.18	90232.0
2011-08-09 19:30:00	SPY	ETF	118.15	118.21	118.07	118.16	156783.0
2011-08-09 04:00:00	QQQ	ETF	50.45	50.6	50.43	50.6	1462.0
2011-08-09 04:30:00	QQQ	ETF	49.8	50.23	49.8	50.23	600.0
2011-08-09 05:00:00	QQQ	ETF	49.85	49.85	49.54	49.62	900.0
2011-08-09 05:30:00	QQQ	ETF	50.1	50.4	50.1	50.12	7093.0
2011-08-09 06:00:00	QQQ	ETF	50.31	50.37	50.17	50.37	898.0
2011-08-09 06:30:00	QQQ	ETF	50.3	50.71	50.27	50.71	17868.0
2011-08-09 07:00:00	QQQ	ETF	50.6	51.23	50.6	50.99	237526.0
2011-08-09 07:30:00	QQQ	ETF	51.03	51.15	50.56	50.94	360627.0
2011-08-09 08:00:00	QQQ	ETF	50.93	51.02	50.7	50.7	628604.0
2011-08-09 08:30:00	QQQ	ETF	50.71	51.05	50.6	50.9	720882.0
2011-08-09 09:00:00	QQQ	ETF	50.9	51.35	50.72	51.3	1909230.0
2011-08-09 09:30:00	QQQ	ETF	51.29	51.7	50.67	51.69	21756223.0
2011-08-09 10:00:00	QQQ	ETF	51.69	52.09	51.63	52.08	15644980.0
2011-08-09 10:30:00	QQQ	ETF	52.09	52.23	51.79	52.07	11000938.0
2011-08-09 11:00:00	QQQ	ETF	52.06	52.1	51.6	52.1	7943048.0
2011-08-09 11:30:00	QQQ	ETF	52.1	52.295	51.935	52.21	5331325.0
2011-08-09 12:00:00	QQQ	ETF	52.2007	52.32	51.8297	52.24	5689167.0
2011-08-09 12:30:00	QQQ	ETF	52.23	52.3699	51.96	51.97	4240813.0

> showing 50 of 11,110 rows — these rows as CSV

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