PREVIEW / etf_30min / 2013-05-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-29.parquet
  size:    331 KB
  rows:    11,131

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-05-29 04:00:00	SPY	ETF	165.4	165.58	165.35	165.41	27000.0
2013-05-29 04:30:00	SPY	ETF	165.35	165.35	165.27	165.27	13400.0
2013-05-29 05:00:00	SPY	ETF	165.32	165.38	165.28	165.34	800.0
2013-05-29 05:30:00	SPY	ETF	165.38	165.45	165.38	165.45	3200.0
2013-05-29 06:00:00	SPY	ETF	165.31	165.32	165.25	165.28	17943.0
2013-05-29 06:30:00	SPY	ETF	165.27	165.27	164.85	164.92	168575.0
2013-05-29 07:00:00	SPY	ETF	164.93	165.0	164.73	164.97	440601.0
2013-05-29 07:30:00	SPY	ETF	164.97	165.13	164.75	164.86	286856.0
2013-05-29 08:00:00	SPY	ETF	164.86	165.2	164.76	165.17	476359.0
2013-05-29 08:30:00	SPY	ETF	165.19	165.33	165.0	165.2	561352.0
2013-05-29 09:00:00	SPY	ETF	165.2	166.3	165.19	165.41	1067146.0
2013-05-29 09:30:00	SPY	ETF	165.42	165.63	164.95	165.33	22688129.0
2013-05-29 10:00:00	SPY	ETF	165.335	165.72	164.95	165.04	13515169.0
2013-05-29 10:30:00	SPY	ETF	165.04	165.2	164.51	164.54	13997148.0
2013-05-29 11:00:00	SPY	ETF	164.55	164.88	164.34	164.8	13299042.0
2013-05-29 11:30:00	SPY	ETF	164.8	165.19	164.75	165.11	9280959.0
2013-05-29 12:00:00	SPY	ETF	165.109	165.24	164.83	164.9	6825610.0
2013-05-29 12:30:00	SPY	ETF	164.892	165.1	164.58	164.65	7212434.0
2013-05-29 13:00:00	SPY	ETF	164.65	165.14	164.535	165.1215	8976533.0
2013-05-29 13:30:00	SPY	ETF	165.13	165.67	164.97	165.57	11390410.0
2013-05-29 14:00:00	SPY	ETF	165.575	165.8	165.46	165.51	8904188.0
2013-05-29 14:30:00	SPY	ETF	165.515	165.66	165.31	165.32	7320704.0
2013-05-29 15:00:00	SPY	ETF	165.32	165.64	165.21	165.59	8029195.0
2013-05-29 15:30:00	SPY	ETF	165.59	165.68	165.13	165.22	16400688.0
2013-05-29 16:00:00	SPY	ETF	165.26	165.6416	165.11	165.21	4335333.0
2013-05-29 16:30:00	SPY	ETF	165.22	165.29	165.1	165.11	394914.0
2013-05-29 17:00:00	SPY	ETF	165.13	165.2	165.12	165.2	52362.0
2013-05-29 17:30:00	SPY	ETF	165.19	165.2	165.13	165.17	72721.0
2013-05-29 18:00:00	SPY	ETF	165.17	165.23	165.02	165.09	109832.0
2013-05-29 18:30:00	SPY	ETF	165.09	165.11	165.08	165.1	3250.0
2013-05-29 19:00:00	SPY	ETF	165.1	165.11	165.05	165.06	14521.0
2013-05-29 19:30:00	SPY	ETF	165.06	165.18	165.06	165.14	21639.0
2013-05-29 04:00:00	QQQ	ETF	73.6	73.6	73.5	73.55	9575.0
2013-05-29 04:30:00	QQQ	ETF	73.49	73.49	73.49	73.49	200.0
2013-05-29 05:00:00	QQQ	ETF	73.45	73.52	73.45	73.52	1200.0
2013-05-29 05:30:00	QQQ	ETF	73.55	73.55	73.54	73.54	500.0
2013-05-29 06:00:00	QQQ	ETF	73.53	73.53	73.51	73.51	1700.0
2013-05-29 06:30:00	QQQ	ETF	73.48	73.48	73.34	73.34	2699.0
2013-05-29 07:00:00	QQQ	ETF	73.34	73.34	73.25	73.31	4753.0
2013-05-29 07:30:00	QQQ	ETF	73.37	73.39	73.24	73.3	40800.0
2013-05-29 08:00:00	QQQ	ETF	73.29	73.43	73.27	73.42	113496.0
2013-05-29 08:30:00	QQQ	ETF	73.4	73.55	73.37	73.5	115652.0
2013-05-29 09:00:00	QQQ	ETF	73.5	73.59	73.5	73.58	465283.0
2013-05-29 09:30:00	QQQ	ETF	73.59	73.67	73.38	73.49	5486782.0
2013-05-29 10:00:00	QQQ	ETF	73.49	73.67	73.33	73.38	2672050.0
2013-05-29 10:30:00	QQQ	ETF	73.36	73.4	73.19	73.22	2416274.0
2013-05-29 11:00:00	QQQ	ETF	73.22	73.4	73.12	73.37	2693345.0
2013-05-29 11:30:00	QQQ	ETF	73.37	73.535	73.35	73.49	1927975.0
2013-05-29 12:00:00	QQQ	ETF	73.5	73.565	73.38	73.42	1185053.0
2013-05-29 12:30:00	QQQ	ETF	73.42	73.46	73.27	73.31	2086942.0

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

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