PREVIEW / etf_30min / 2014-08-08

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-08.parquet
  size:    342 KB
  rows:    11,479

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-08-08 04:00:00	SPY	ETF	189.94	190.11	189.61	190.11	42678.0
2014-08-08 04:30:00	SPY	ETF	190.12	190.45	190.12	190.3	59207.0
2014-08-08 05:00:00	SPY	ETF	190.25	190.37	190.18	190.36	21043.0
2014-08-08 05:30:00	SPY	ETF	190.32	190.41	190.27	190.28	40126.0
2014-08-08 06:00:00	SPY	ETF	190.33	190.73	190.33	190.63	88204.0
2014-08-08 06:30:00	SPY	ETF	190.61	190.82	190.55	190.67	127406.0
2014-08-08 07:00:00	SPY	ETF	190.69	191.56	190.64	191.4	851583.0
2014-08-08 07:30:00	SPY	ETF	191.4	191.63	191.31	191.4	519358.0
2014-08-08 08:00:00	SPY	ETF	191.55	191.74	190.59	191.66	1105603.0
2014-08-08 08:30:00	SPY	ETF	191.67	191.94	191.51	191.63	1375512.0
2014-08-08 09:00:00	SPY	ETF	191.63	191.69	191.4	191.45	938813.0
2014-08-08 09:30:00	SPY	ETF	191.46	191.61	190.99	191.3	13858805.0
2014-08-08 10:00:00	SPY	ETF	191.3	191.66	190.95	191.09	10355540.0
2014-08-08 10:30:00	SPY	ETF	191.09	191.88	191.0	191.67	7411096.0
2014-08-08 11:00:00	SPY	ETF	191.67	192.02	191.515	191.97	5869653.0
2014-08-08 11:30:00	SPY	ETF	191.965	192.07	191.795	191.99	5485656.0
2014-08-08 12:00:00	SPY	ETF	191.98	192.03	191.7	191.755	3995440.0
2014-08-08 12:30:00	SPY	ETF	191.755	191.88	191.62	191.8	2318839.0
2014-08-08 13:00:00	SPY	ETF	191.79	192.89	191.72	192.75	9212322.0
2014-08-08 13:30:00	SPY	ETF	192.75	192.93	192.61	192.815	9147952.0
2014-08-08 14:00:00	SPY	ETF	192.815	192.98	192.69	192.931	5284884.0
2014-08-08 14:30:00	SPY	ETF	192.94	193.02	192.77	192.79	5696872.0
2014-08-08 15:00:00	SPY	ETF	192.79	193.12	192.65	193.1	5422788.0
2014-08-08 15:30:00	SPY	ETF	193.1	193.37	193.03	193.24	15642449.0
2014-08-08 16:00:00	SPY	ETF	193.23	193.2699	191.45	192.96	6560778.0
2014-08-08 16:30:00	SPY	ETF	192.95	192.98	192.92	192.95	1973426.0
2014-08-08 17:00:00	SPY	ETF	192.95	193.02	192.91	193.02	517281.0
2014-08-08 17:30:00	SPY	ETF	193.02	193.07	192.96	193.0	2111931.0
2014-08-08 18:00:00	SPY	ETF	193.01	193.02	192.98	193.02	14176.0
2014-08-08 18:30:00	SPY	ETF	192.98	193.05	192.98	193.04	12100.0
2014-08-08 19:00:00	SPY	ETF	193.02	193.05	193.02	193.02	6502.0
2014-08-08 19:30:00	SPY	ETF	193.06	193.06	192.95	193.01	17769.0
2014-08-08 04:00:00	QQQ	ETF	93.75	93.75	93.62	93.62	778.0
2014-08-08 04:30:00	QQQ	ETF	93.78	93.9	93.78	93.85	21400.0
2014-08-08 05:00:00	QQQ	ETF	93.83	93.86	93.83	93.86	450.0
2014-08-08 05:30:00	QQQ	ETF	93.89	93.91	93.89	93.91	300.0
2014-08-08 06:00:00	QQQ	ETF	93.92	94.05	93.92	94.01	7550.0
2014-08-08 06:30:00	QQQ	ETF	94.0	94.1	94.0	94.03	7210.0
2014-08-08 07:00:00	QQQ	ETF	94.03	94.44	94.03	94.39	129350.0
2014-08-08 07:30:00	QQQ	ETF	94.41	94.46	94.35	94.38	260390.0
2014-08-08 08:00:00	QQQ	ETF	94.37	94.49	93.58	94.48	312733.0
2014-08-08 08:30:00	QQQ	ETF	94.48	94.61	94.43	94.46	167835.0
2014-08-08 09:00:00	QQQ	ETF	94.45	94.49	94.22	94.38	241921.0
2014-08-08 09:30:00	QQQ	ETF	94.38	94.45	94.12	94.31	4823537.0
2014-08-08 10:00:00	QQQ	ETF	94.3	94.47	93.97	94.02	3265895.0
2014-08-08 10:30:00	QQQ	ETF	94.02	94.4588	93.97	94.36	3366388.0
2014-08-08 11:00:00	QQQ	ETF	94.35	94.5	94.2901	94.46	3012553.0
2014-08-08 11:30:00	QQQ	ETF	94.47	94.53	94.345	94.445	2382950.0
2014-08-08 12:00:00	QQQ	ETF	94.45	94.4801	94.3	94.325	1705871.0
2014-08-08 12:30:00	QQQ	ETF	94.3299	94.38	94.25	94.34	879245.0

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

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