PREVIEW / etf_30min / 2013-09-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-11.parquet
  size:    325 KB
  rows:    10,885

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-09-11 04:00:00	SPY	ETF	168.64	168.75	168.64	168.75	700.0
2013-09-11 04:30:00	SPY	ETF	168.73	168.88	168.72	168.88	3000.0
2013-09-11 05:00:00	SPY	ETF	168.85	168.85	168.82	168.82	700.0
2013-09-11 05:30:00	SPY	ETF	168.72	168.72	168.64	168.64	1500.0
2013-09-11 06:00:00	SPY	ETF	168.68	168.83	168.67	168.83	27070.0
2013-09-11 06:30:00	SPY	ETF	168.82	168.84	168.76	168.78	21006.0
2013-09-11 07:00:00	SPY	ETF	168.76	168.84	168.74	168.8	113210.0
2013-09-11 07:30:00	SPY	ETF	168.79	168.82	168.57	168.59	223239.0
2013-09-11 08:00:00	SPY	ETF	168.59	168.8	168.57	168.59	142750.0
2013-09-11 08:30:00	SPY	ETF	168.63	168.72	168.59	168.68	587575.0
2013-09-11 09:00:00	SPY	ETF	168.68	168.71	168.5	168.63	593798.0
2013-09-11 09:30:00	SPY	ETF	168.64	168.84	168.43	168.49	10686794.0
2013-09-11 10:00:00	SPY	ETF	168.5	168.71	168.35	168.38	7617143.0
2013-09-11 10:30:00	SPY	ETF	168.38	168.59	168.36	168.57	6595684.0
2013-09-11 11:00:00	SPY	ETF	168.57	168.78	168.57	168.73	4977461.0
2013-09-11 11:30:00	SPY	ETF	168.73	169.13	168.73	169.03	5439146.0
2013-09-11 12:00:00	SPY	ETF	169.03	169.14	168.93	169.14	3813642.0
2013-09-11 12:30:00	SPY	ETF	169.13	169.18	169.03	169.16	2929893.0
2013-09-11 13:00:00	SPY	ETF	169.151	169.16	169.05	169.13	5356516.0
2013-09-11 13:30:00	SPY	ETF	169.13	169.31	169.12	169.24	4004501.0
2013-09-11 14:00:00	SPY	ETF	169.24	169.32	169.12	169.2	4331308.0
2013-09-11 14:30:00	SPY	ETF	169.2	169.25	169.08	169.115	3140423.0
2013-09-11 15:00:00	SPY	ETF	169.12	169.17	169.0	169.01	5762437.0
2013-09-11 15:30:00	SPY	ETF	169.01	169.4	168.99	169.4	13409706.0
2013-09-11 16:00:00	SPY	ETF	169.4	169.48	168.5244	169.48	5777744.0
2013-09-11 16:30:00	SPY	ETF	169.47	169.55	168.8882	169.54	4374298.0
2013-09-11 17:00:00	SPY	ETF	169.55	169.59	168.8787	169.56	507144.0
2013-09-11 17:30:00	SPY	ETF	169.58	169.61	169.56	169.56	25692.0
2013-09-11 18:00:00	SPY	ETF	169.55	169.55	169.0754	169.49	55330.0
2013-09-11 18:30:00	SPY	ETF	169.5	169.5	169.46	169.47	73755.0
2013-09-11 19:00:00	SPY	ETF	169.5	169.5	169.43	169.47	53110.0
2013-09-11 19:30:00	SPY	ETF	169.47	169.54	169.42	169.45	67550.0
2013-09-11 05:30:00	QQQ	ETF	78.03	78.03	78.03	78.03	100.0
2013-09-11 06:00:00	QQQ	ETF	77.98	78.05	77.98	78.03	500.0
2013-09-11 06:30:00	QQQ	ETF	78.03	78.05	78.0	78.03	9778.0
2013-09-11 07:00:00	QQQ	ETF	78.02	78.02	77.95	77.95	53500.0
2013-09-11 07:30:00	QQQ	ETF	77.92	77.93	77.79	77.83	67220.0
2013-09-11 08:00:00	QQQ	ETF	77.83	77.88	77.8	77.83	112225.0
2013-09-11 08:30:00	QQQ	ETF	77.82	77.87	77.81	77.86	108665.0
2013-09-11 09:00:00	QQQ	ETF	77.86	77.86	77.67	77.71	538083.0
2013-09-11 09:30:00	QQQ	ETF	77.69	77.93	77.67	77.7	4076133.0
2013-09-11 10:00:00	QQQ	ETF	77.7	77.87	77.59	77.62	2375345.0
2013-09-11 10:30:00	QQQ	ETF	77.62	77.74	77.59	77.73	1852249.0
2013-09-11 11:00:00	QQQ	ETF	77.74	77.88	77.7201	77.84	2275667.0
2013-09-11 11:30:00	QQQ	ETF	77.84	77.96	77.84	77.9	1482697.0
2013-09-11 12:00:00	QQQ	ETF	77.9	78.01	77.87	77.99	2426174.0
2013-09-11 12:30:00	QQQ	ETF	77.99	78.01	77.905	78.0	969654.0
2013-09-11 13:00:00	QQQ	ETF	77.99	78.0	77.91	77.99	992779.0
2013-09-11 13:30:00	QQQ	ETF	77.99	78.09	77.985	78.04	1843915.0
2013-09-11 14:00:00	QQQ	ETF	78.03	78.09	77.96	78.04	973957.0

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

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