PREVIEW / etf_30min / 2014-09-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-10.parquet
  size:    341 KB
  rows:    11,469

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
2014-09-10 04:00:00	SPY	ETF	199.33	199.34	199.21	199.28	7751.0
2014-09-10 04:30:00	SPY	ETF	199.26	199.26	199.25	199.25	301.0
2014-09-10 05:00:00	SPY	ETF	199.33	199.42	199.33	199.42	3585.0
2014-09-10 05:30:00	SPY	ETF	199.36	199.71	199.34	199.71	68264.0
2014-09-10 06:00:00	SPY	ETF	199.7	199.83	199.61	199.61	7695.0
2014-09-10 06:30:00	SPY	ETF	199.61	199.75	199.59	199.72	90549.0
2014-09-10 07:00:00	SPY	ETF	199.7	199.79	199.51	199.53	94037.0
2014-09-10 07:30:00	SPY	ETF	199.5	199.54	199.36	199.52	64894.0
2014-09-10 08:00:00	SPY	ETF	199.54	199.62	199.37	199.37	113707.0
2014-09-10 08:30:00	SPY	ETF	199.37	199.4	199.26	199.4	218826.0
2014-09-10 09:00:00	SPY	ETF	199.37	199.5	199.34	199.44	256583.0
2014-09-10 09:30:00	SPY	ETF	199.43	199.59	198.91	199.025	9719676.0
2014-09-10 10:00:00	SPY	ETF	199.03	199.29	198.87	199.18	7207351.0
2014-09-10 10:30:00	SPY	ETF	199.18	199.19	198.77	198.97	5625066.0
2014-09-10 11:00:00	SPY	ETF	198.98	199.36	198.84	199.3	4935195.0
2014-09-10 11:30:00	SPY	ETF	199.31	199.55	199.3	199.4599	3163225.0
2014-09-10 12:00:00	SPY	ETF	199.45	199.8	199.34	199.68	3446969.0
2014-09-10 12:30:00	SPY	ETF	199.69	199.78	199.57	199.5999	2625912.0
2014-09-10 13:00:00	SPY	ETF	199.6	200.17	199.59	199.98	4393960.0
2014-09-10 13:30:00	SPY	ETF	199.99	200.02	199.78	199.875	3219386.0
2014-09-10 14:00:00	SPY	ETF	199.88	200.04	199.8	199.89	2226920.0
2014-09-10 14:30:00	SPY	ETF	199.88	199.92	199.72	199.8	3283694.0
2014-09-10 15:00:00	SPY	ETF	199.8	200.2	199.79	200.0752	4782244.0
2014-09-10 15:30:00	SPY	ETF	200.08	200.18	199.97	200.08	7645881.0
2014-09-10 16:00:00	SPY	ETF	200.1	200.12	200.06	200.09	2660738.0
2014-09-10 16:30:00	SPY	ETF	200.09	200.14	200.06	200.14	93129.0
2014-09-10 17:00:00	SPY	ETF	200.14	200.14	200.06	200.08	134974.0
2014-09-10 17:30:00	SPY	ETF	200.08	200.09	200.03	200.05	49755.0
2014-09-10 18:00:00	SPY	ETF	200.04	200.09	199.95	199.97	43153.0
2014-09-10 18:30:00	SPY	ETF	199.97	200.0	199.9	200.0	34364.0
2014-09-10 19:00:00	SPY	ETF	199.98	200.0	199.96	199.96	8450.0
2014-09-10 19:30:00	SPY	ETF	200.0	200.05	199.99	200.05	5086.0
2014-09-10 04:00:00	QQQ	ETF	99.15	99.15	99.15	99.15	5000.0
2014-09-10 05:00:00	QQQ	ETF	99.21	99.21	99.21	99.21	500.0
2014-09-10 06:00:00	QQQ	ETF	99.52	99.52	99.48	99.49	21300.0
2014-09-10 06:30:00	QQQ	ETF	99.47	99.55	99.47	99.55	21329.0
2014-09-10 07:00:00	QQQ	ETF	99.52	99.53	99.39	99.39	47100.0
2014-09-10 07:30:00	QQQ	ETF	99.38	99.38	99.32	99.37	33350.0
2014-09-10 08:00:00	QQQ	ETF	99.38	99.4	99.29	99.29	141318.0
2014-09-10 08:30:00	QQQ	ETF	99.3	99.34	99.24	99.34	55808.0
2014-09-10 09:00:00	QQQ	ETF	99.32	99.39	99.32	99.38	198477.0
2014-09-10 09:30:00	QQQ	ETF	99.38	99.57	99.17	99.25	5250084.0
2014-09-10 10:00:00	QQQ	ETF	99.25	99.39	99.1	99.3	2561733.0
2014-09-10 10:30:00	QQQ	ETF	99.309	99.47	99.11	99.3701	2234040.0
2014-09-10 11:00:00	QQQ	ETF	99.37	99.54	99.25	99.5	1675978.0
2014-09-10 11:30:00	QQQ	ETF	99.5	99.62	99.48	99.59	1510165.0
2014-09-10 12:00:00	QQQ	ETF	99.58	99.78	99.51	99.721	1529271.0
2014-09-10 12:30:00	QQQ	ETF	99.73	99.87	99.7	99.7807	1142030.0
2014-09-10 13:00:00	QQQ	ETF	99.79	100.067	99.79	100.0	2131139.0
2014-09-10 13:30:00	QQQ	ETF	99.99	100.0	99.855	99.9	1632683.0

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

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