PREVIEW / etf_30min / 2011-06-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-14.parquet
  size:    279 KB
  rows:    9,255

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-06-14 04:00:00	SPY	ETF	128.35	128.88	128.35	128.8	2690.0
2011-06-14 04:30:00	SPY	ETF	128.8	128.84	128.7	128.84	3765.0
2011-06-14 05:00:00	SPY	ETF	128.8	128.92	128.71	128.71	4444.0
2011-06-14 05:30:00	SPY	ETF	128.71	128.74	128.64	128.64	4300.0
2011-06-14 06:00:00	SPY	ETF	128.66	128.71	128.65	128.7	4200.0
2011-06-14 06:30:00	SPY	ETF	128.68	128.69	128.42	128.43	53649.0
2011-06-14 07:00:00	SPY	ETF	128.45	128.66	128.42	128.6	282780.0
2011-06-14 07:30:00	SPY	ETF	128.6	128.64	128.5	128.6	261075.0
2011-06-14 08:00:00	SPY	ETF	128.6	128.93	128.01	128.63	964391.0
2011-06-14 08:30:00	SPY	ETF	128.59	129.11	128.59	129.06	2803125.0
2011-06-14 09:00:00	SPY	ETF	129.05	129.09	128.85	128.88	1942301.0
2011-06-14 09:30:00	SPY	ETF	128.87	129.24	128.82	129.14	18759514.0
2011-06-14 10:00:00	SPY	ETF	129.14	129.3	129.03	129.27	11577160.0
2011-06-14 10:30:00	SPY	ETF	129.26	129.44	129.22	129.32	16335732.0
2011-06-14 11:00:00	SPY	ETF	129.315	129.37	129.17	129.22	7091408.0
2011-06-14 11:30:00	SPY	ETF	129.22	129.41	129.14	129.38	6076778.0
2011-06-14 12:00:00	SPY	ETF	129.39	129.46	129.24	129.41	7570036.0
2011-06-14 12:30:00	SPY	ETF	129.4	129.56	129.36	129.5	4304737.0
2011-06-14 13:00:00	SPY	ETF	129.5	129.6	129.39	129.57	4763814.0
2011-06-14 13:30:00	SPY	ETF	129.57	129.7	129.44	129.48	8203109.0
2011-06-14 14:00:00	SPY	ETF	129.48	129.64	129.4	129.6	6003826.0
2011-06-14 14:30:00	SPY	ETF	129.59	129.7	129.49	129.63	6897973.0
2011-06-14 15:00:00	SPY	ETF	129.64	129.77	129.435	129.54	10077274.0
2011-06-14 15:30:00	SPY	ETF	129.54	129.54	129.18	129.31	28830772.0
2011-06-14 16:00:00	SPY	ETF	129.31	129.55	129.08	129.42	13403231.0
2011-06-14 16:30:00	SPY	ETF	129.43	129.43	127.6917	129.38	1676935.0
2011-06-14 17:00:00	SPY	ETF	129.38	129.42	129.36	129.38	196579.0
2011-06-14 17:30:00	SPY	ETF	129.36	129.4	129.35	129.4	19692.0
2011-06-14 18:00:00	SPY	ETF	129.39	129.44	129.32	129.38	274669.0
2011-06-14 18:30:00	SPY	ETF	129.38	129.46	129.38	129.4	120585.0
2011-06-14 19:00:00	SPY	ETF	129.4	129.4	129.32	129.38	25601.0
2011-06-14 19:30:00	SPY	ETF	129.39	129.42	129.3	129.36	23563.0
2011-06-14 04:00:00	QQQ	ETF	55.04	55.09	55.04	55.09	1100.0
2011-06-14 05:30:00	QQQ	ETF	54.99	55.0	54.99	55.0	1300.0
2011-06-14 06:00:00	QQQ	ETF	54.98	55.0	54.98	55.0	2000.0
2011-06-14 06:30:00	QQQ	ETF	54.98	54.98	54.9	54.9	4800.0
2011-06-14 07:00:00	QQQ	ETF	54.91	54.97	54.91	54.97	13200.0
2011-06-14 07:30:00	QQQ	ETF	54.94	54.98	54.94	54.98	107350.0
2011-06-14 08:00:00	QQQ	ETF	54.97	55.03	54.97	55.01	512976.0
2011-06-14 08:30:00	QQQ	ETF	55.0	55.2	55.0	55.18	830336.0
2011-06-14 09:00:00	QQQ	ETF	55.17	55.18	55.05	55.05	598230.0
2011-06-14 09:30:00	QQQ	ETF	55.05	55.27	55.03	55.23	6823709.0
2011-06-14 10:00:00	QQQ	ETF	55.2201	55.36	55.19	55.32	2855377.0
2011-06-14 10:30:00	QQQ	ETF	55.33	55.41	55.33	55.38	2440173.0
2011-06-14 11:00:00	QQQ	ETF	55.37	55.39	55.3	55.32	1668572.0
2011-06-14 11:30:00	QQQ	ETF	55.32	55.355	55.28	55.335	1624809.0
2011-06-14 12:00:00	QQQ	ETF	55.34	55.39	55.3	55.35	1791351.0
2011-06-14 12:30:00	QQQ	ETF	55.355	55.371	55.31	55.34	1457641.0
2011-06-14 13:00:00	QQQ	ETF	55.34	55.39	55.29	55.3757	1285755.0
2011-06-14 13:30:00	QQQ	ETF	55.38	55.46	55.35	55.4	2919512.0

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

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