PREVIEW / etf_30min / 2013-03-13

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-13.parquet
  size:    299 KB
  rows:    10,200

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-03-13 04:30:00	SPY	ETF	155.57	155.61	155.56	155.56	5000.0
2013-03-13 05:00:00	SPY	ETF	155.51	155.56	155.5	155.55	5100.0
2013-03-13 05:30:00	SPY	ETF	155.55	155.6	155.47	155.48	31300.0
2013-03-13 06:00:00	SPY	ETF	155.55	155.55	155.42	155.47	24428.0
2013-03-13 06:30:00	SPY	ETF	155.47	155.47	155.38	155.4	4890.0
2013-03-13 07:00:00	SPY	ETF	155.4	155.41	155.29	155.35	114066.0
2013-03-13 07:30:00	SPY	ETF	155.35	155.4	155.28	155.33	162687.0
2013-03-13 08:00:00	SPY	ETF	155.31	155.46	155.27	155.42	371968.0
2013-03-13 08:30:00	SPY	ETF	155.48	155.87	155.46	155.82	1332237.0
2013-03-13 09:00:00	SPY	ETF	155.82	155.82	155.73	155.76	460429.0
2013-03-13 09:30:00	SPY	ETF	155.76	155.82	155.23	155.55	14194762.0
2013-03-13 10:00:00	SPY	ETF	155.55	155.59	155.3	155.51	6032784.0
2013-03-13 10:30:00	SPY	ETF	155.5	155.75	155.42	155.7099	5278937.0
2013-03-13 11:00:00	SPY	ETF	155.71	155.81	155.64	155.69	4996535.0
2013-03-13 11:30:00	SPY	ETF	155.68	155.74	155.55	155.59	5495735.0
2013-03-13 12:00:00	SPY	ETF	155.59	155.92	155.57	155.9	5034506.0
2013-03-13 12:30:00	SPY	ETF	155.9	156.04	155.84	155.94	4535381.0
2013-03-13 13:00:00	SPY	ETF	155.94	155.97	155.83	155.96	2992073.0
2013-03-13 13:30:00	SPY	ETF	155.95	156.12	155.92	156.045	3192705.0
2013-03-13 14:00:00	SPY	ETF	156.04	156.08	155.8896	155.99	4661915.0
2013-03-13 14:30:00	SPY	ETF	155.99	156.0555	155.85	155.89	3470893.0
2013-03-13 15:00:00	SPY	ETF	155.895	155.95	155.7025	155.885	4762278.0
2013-03-13 15:30:00	SPY	ETF	155.89	156.01	155.85	155.88	9944758.0
2013-03-13 16:00:00	SPY	ETF	155.86	156.05	155.7025	156.02	11041194.0
2013-03-13 16:30:00	SPY	ETF	156.02	156.14	155.9701	156.1	1356175.0
2013-03-13 17:00:00	SPY	ETF	156.11	156.13	156.07	156.08	1046733.0
2013-03-13 17:30:00	SPY	ETF	156.08	156.08	155.97	156.04	235955.0
2013-03-13 18:00:00	SPY	ETF	156.05	156.09	155.97	155.97	154665.0
2013-03-13 18:30:00	SPY	ETF	155.96	156.05	155.96	156.05	5603.0
2013-03-13 19:00:00	SPY	ETF	156.01	156.07	155.99	155.99	11073.0
2013-03-13 19:30:00	SPY	ETF	156.0	156.04	155.99	156.01	27541.0
2013-03-13 05:00:00	QQQ	ETF	68.68	68.68	68.68	68.68	4800.0
2013-03-13 05:30:00	QQQ	ETF	68.7	68.7	68.65	68.65	7200.0
2013-03-13 06:00:00	QQQ	ETF	68.65	68.65	68.65	68.65	4800.0
2013-03-13 06:30:00	QQQ	ETF	68.65	68.65	68.63	68.65	21000.0
2013-03-13 07:00:00	QQQ	ETF	68.63	68.63	68.58	68.62	13160.0
2013-03-13 07:30:00	QQQ	ETF	68.64	68.64	68.6	68.6	28550.0
2013-03-13 08:00:00	QQQ	ETF	68.6	68.68	68.6	68.68	9384.0
2013-03-13 08:30:00	QQQ	ETF	68.66	68.81	68.66	68.8	141719.0
2013-03-13 09:00:00	QQQ	ETF	68.78	68.8	68.78	68.78	32426.0
2013-03-13 09:30:00	QQQ	ETF	68.8	68.81	68.44	68.54	2859506.0
2013-03-13 10:00:00	QQQ	ETF	68.54	68.57	68.39	68.52	2398864.0
2013-03-13 10:30:00	QQQ	ETF	68.52	68.7201	68.51	68.69	1429388.0
2013-03-13 11:00:00	QQQ	ETF	68.68	68.73	68.62	68.63	902243.0
2013-03-13 11:30:00	QQQ	ETF	68.63	68.66	68.535	68.54	1641799.0
2013-03-13 12:00:00	QQQ	ETF	68.55	68.73	68.53	68.73	953129.0
2013-03-13 12:30:00	QQQ	ETF	68.74	68.79	68.71	68.76	1685490.0
2013-03-13 13:00:00	QQQ	ETF	68.7501	68.79	68.7099	68.76	965767.0
2013-03-13 13:30:00	QQQ	ETF	68.76	68.89	68.75	68.86	995021.0
2013-03-13 14:00:00	QQQ	ETF	68.85	68.87	68.76	68.8	643223.0

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

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