PREVIEW / etf_30min / 2013-11-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-04.parquet
  size:    316 KB
  rows:    10,949

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-11-04 04:00:00	SPY	ETF	176.21	176.35	176.21	176.35	14114.0
2013-11-04 04:30:00	SPY	ETF	176.32	176.32	176.22	176.22	25429.0
2013-11-04 05:00:00	SPY	ETF	176.18	176.23	176.17	176.18	1700.0
2013-11-04 05:30:00	SPY	ETF	176.15	176.25	176.15	176.25	18042.0
2013-11-04 06:00:00	SPY	ETF	176.25	176.42	176.25	176.36	31869.0
2013-11-04 06:30:00	SPY	ETF	176.38	176.42	176.37	176.42	10840.0
2013-11-04 07:00:00	SPY	ETF	176.4	176.5	176.36	176.48	94091.0
2013-11-04 07:30:00	SPY	ETF	176.5	176.62	176.48	176.59	269741.0
2013-11-04 08:00:00	SPY	ETF	176.56	176.6	176.0	176.55	747986.0
2013-11-04 08:30:00	SPY	ETF	176.57	176.71	176.53	176.69	683793.0
2013-11-04 09:00:00	SPY	ETF	176.67	176.77	176.65	176.68	1896423.0
2013-11-04 09:30:00	SPY	ETF	176.69	176.8	176.32	176.45	9789214.0
2013-11-04 10:00:00	SPY	ETF	176.451	176.5	176.265	176.46	5474484.0
2013-11-04 10:30:00	SPY	ETF	176.4699	176.62	176.22	176.2224	4859108.0
2013-11-04 11:00:00	SPY	ETF	176.23	176.33	176.1499	176.27	6112188.0
2013-11-04 11:30:00	SPY	ETF	176.28	176.46	176.22	176.3849	3445656.0
2013-11-04 12:00:00	SPY	ETF	176.39	176.45	176.34	176.439	5271165.0
2013-11-04 12:30:00	SPY	ETF	176.43	176.5	176.34	176.34	3140700.0
2013-11-04 13:00:00	SPY	ETF	176.34	176.52	176.33	176.49	4287408.0
2013-11-04 13:30:00	SPY	ETF	176.49	176.55	176.46	176.53	4614619.0
2013-11-04 14:00:00	SPY	ETF	176.54	176.66	176.51	176.635	3614794.0
2013-11-04 14:30:00	SPY	ETF	176.635	176.71	176.59	176.6029	2371176.0
2013-11-04 15:00:00	SPY	ETF	176.609	176.64	176.46	176.6183	4399865.0
2013-11-04 15:30:00	SPY	ETF	176.62	176.9	176.53	176.82	10566354.0
2013-11-04 16:00:00	SPY	ETF	176.83	176.91	176.164	176.79	7947729.0
2013-11-04 16:30:00	SPY	ETF	176.78	176.86	176.78	176.81	463646.0
2013-11-04 17:00:00	SPY	ETF	176.81	176.82	176.73	176.8	180286.0
2013-11-04 17:30:00	SPY	ETF	176.79	176.8	176.77	176.79	12707.0
2013-11-04 18:00:00	SPY	ETF	176.79	176.79	176.66	176.79	58245.0
2013-11-04 18:30:00	SPY	ETF	176.77	176.81	176.77	176.81	110110.0
2013-11-04 19:00:00	SPY	ETF	176.82	176.84	176.79	176.81	7300.0
2013-11-04 19:30:00	SPY	ETF	176.79	176.82	176.785	176.81	14251.0
2013-11-04 04:00:00	QQQ	ETF	82.88	82.89	82.87	82.89	10900.0
2013-11-04 04:30:00	QQQ	ETF	82.87	82.87	82.87	82.87	1500.0
2013-11-04 05:00:00	QQQ	ETF	82.85	82.85	82.84	82.84	1600.0
2013-11-04 05:30:00	QQQ	ETF	82.86	82.86	82.85	82.85	16500.0
2013-11-04 06:00:00	QQQ	ETF	82.89	82.95	82.89	82.95	4900.0
2013-11-04 06:30:00	QQQ	ETF	82.97	82.98	82.97	82.98	1570.0
2013-11-04 07:00:00	QQQ	ETF	82.98	83.02	82.97	83.02	8400.0
2013-11-04 07:30:00	QQQ	ETF	83.02	83.07	83.02	83.06	12860.0
2013-11-04 08:00:00	QQQ	ETF	83.05	83.05	83.0	83.0	137566.0
2013-11-04 08:30:00	QQQ	ETF	83.02	83.11	83.01	83.1	149379.0
2013-11-04 09:00:00	QQQ	ETF	83.1	83.13	83.05	83.07	165619.0
2013-11-04 09:30:00	QQQ	ETF	83.05	83.07	82.64	82.73	3365989.0
2013-11-04 10:00:00	QQQ	ETF	82.74	82.92	82.655	82.88	1827797.0
2013-11-04 10:30:00	QQQ	ETF	82.889	82.95	82.6901	82.6901	1341517.0
2013-11-04 11:00:00	QQQ	ETF	82.7	82.78	82.665	82.73	1337481.0
2013-11-04 11:30:00	QQQ	ETF	82.73	82.89	82.69	82.86	872236.0
2013-11-04 12:00:00	QQQ	ETF	82.86	82.875	82.765	82.79	467169.0
2013-11-04 12:30:00	QQQ	ETF	82.79	82.819	82.72	82.72	770712.0

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

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