PREVIEW / etf_30min / 2013-04-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-04.parquet
  size:    309 KB
  rows:    10,522

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
2013-04-04 04:00:00	SPY	ETF	155.65	155.78	155.62	155.78	31100.0
2013-04-04 04:30:00	SPY	ETF	155.8	155.94	155.8	155.9	3300.0
2013-04-04 05:00:00	SPY	ETF	155.87	156.04	155.87	156.03	21896.0
2013-04-04 05:30:00	SPY	ETF	156.02	156.04	155.98	156.0	10380.0
2013-04-04 06:00:00	SPY	ETF	155.94	155.97	155.91	155.93	14000.0
2013-04-04 06:30:00	SPY	ETF	155.97	155.97	155.76	155.79	105300.0
2013-04-04 07:00:00	SPY	ETF	155.85	155.95	155.83	155.94	336619.0
2013-04-04 07:30:00	SPY	ETF	155.92	156.0	155.82	155.83	362950.0
2013-04-04 08:00:00	SPY	ETF	155.83	155.92	155.64	155.79	779106.0
2013-04-04 08:30:00	SPY	ETF	155.79	155.79	155.15	155.33	3328111.0
2013-04-04 09:00:00	SPY	ETF	155.34	155.58	155.22	155.43	1259855.0
2013-04-04 09:30:00	SPY	ETF	155.43	156.0	155.31	155.87	16389696.0
2013-04-04 10:00:00	SPY	ETF	155.87	156.17	155.3	155.38	14754901.0
2013-04-04 10:30:00	SPY	ETF	155.37	155.95	155.36	155.69	11089065.0
2013-04-04 11:00:00	SPY	ETF	155.691	155.93	155.6	155.85	6166964.0
2013-04-04 11:30:00	SPY	ETF	155.85	155.85	155.49	155.54	5696648.0
2013-04-04 12:00:00	SPY	ETF	155.53	155.54	155.26	155.35	6620097.0
2013-04-04 12:30:00	SPY	ETF	155.359	155.53	155.31	155.44	4820479.0
2013-04-04 13:00:00	SPY	ETF	155.43	155.45	155.09	155.35	7920821.0
2013-04-04 13:30:00	SPY	ETF	155.35	155.69	155.26	155.58	7233620.0
2013-04-04 14:00:00	SPY	ETF	155.58	155.85	155.48	155.81	6274846.0
2013-04-04 14:30:00	SPY	ETF	155.811	155.84	155.62	155.62	4852997.0
2013-04-04 15:00:00	SPY	ETF	155.63	155.77	155.52	155.56	5542548.0
2013-04-04 15:30:00	SPY	ETF	155.56	155.92	155.55	155.851	12193864.0
2013-04-04 16:00:00	SPY	ETF	155.84	155.98	155.6409	155.85	10341323.0
2013-04-04 16:30:00	SPY	ETF	155.86	155.8727	155.2443	155.2443	4023613.0
2013-04-04 17:00:00	SPY	ETF	155.76	155.88	155.76	155.86	77644.0
2013-04-04 17:30:00	SPY	ETF	155.86	155.89	155.86	155.87	26843.0
2013-04-04 18:00:00	SPY	ETF	155.89	155.92	155.85	155.89	31313.0
2013-04-04 18:30:00	SPY	ETF	155.9	155.9	155.86	155.89	9843.0
2013-04-04 19:00:00	SPY	ETF	155.89	155.89	155.75	155.76	12285.0
2013-04-04 19:30:00	SPY	ETF	155.77	155.84	155.75	155.81	32518.0
2013-04-04 20:00:00	SPY	ETF	155.94	155.94	155.94	155.94	100.0
2013-04-04 06:00:00	QQQ	ETF	68.7	68.71	68.69	68.7	5591.0
2013-04-04 06:30:00	QQQ	ETF	68.7	68.7	68.66	68.66	1400.0
2013-04-04 07:00:00	QQQ	ETF	68.68	68.7	68.66	68.68	12370.0
2013-04-04 07:30:00	QQQ	ETF	68.68	68.68	68.68	68.68	300.0
2013-04-04 08:00:00	QQQ	ETF	68.63	68.63	68.54	68.61	33200.0
2013-04-04 08:30:00	QQQ	ETF	68.61	68.61	68.33	68.38	593947.0
2013-04-04 09:00:00	QQQ	ETF	68.38	68.45	68.35	68.4	445693.0
2013-04-04 09:30:00	QQQ	ETF	68.41	68.525	68.27	68.46	4509810.0
2013-04-04 10:00:00	QQQ	ETF	68.47	68.6	68.1825	68.22	3019969.0
2013-04-04 10:30:00	QQQ	ETF	68.21	68.445	68.2	68.26	2732200.0
2013-04-04 11:00:00	QQQ	ETF	68.27	68.41	68.26	68.38	1649600.0
2013-04-04 11:30:00	QQQ	ETF	68.38	68.38	68.2601	68.29	1168921.0
2013-04-04 12:00:00	QQQ	ETF	68.285	68.285	68.06	68.165	2333443.0
2013-04-04 12:30:00	QQQ	ETF	68.16	68.32	68.16	68.255	1327592.0
2013-04-04 13:00:00	QQQ	ETF	68.26	68.29	68.1313	68.26	1188906.0
2013-04-04 13:30:00	QQQ	ETF	68.27	68.42	68.2312	68.39	1570990.0
2013-04-04 14:00:00	QQQ	ETF	68.38	68.47	68.34	68.45	1109617.0

> showing 50 of 10,522 rows — these rows as CSV

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