PREVIEW / etf_30min / 2014-09-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-25.parquet
  size:    361 KB
  rows:    12,146

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-25 04:00:00	SPY	ETF	199.43	199.43	199.41	199.41	367.0
2014-09-25 04:30:00	SPY	ETF	199.55	199.56	199.37	199.37	4896.0
2014-09-25 05:00:00	SPY	ETF	199.42	199.43	199.37	199.37	20548.0
2014-09-25 05:30:00	SPY	ETF	199.42	199.44	199.4	199.4	23172.0
2014-09-25 06:00:00	SPY	ETF	199.38	199.4	199.31	199.33	11259.0
2014-09-25 06:30:00	SPY	ETF	199.37	199.52	199.37	199.49	14320.0
2014-09-25 07:00:00	SPY	ETF	199.48	199.5	199.44	199.5	8314.0
2014-09-25 07:30:00	SPY	ETF	199.46	199.6	199.45	199.49	102242.0
2014-09-25 08:00:00	SPY	ETF	199.49	199.49	199.12	199.2	336979.0
2014-09-25 08:30:00	SPY	ETF	199.18	199.29	198.94	199.02	924531.0
2014-09-25 09:00:00	SPY	ETF	199.01	199.07	198.91	199.03	837865.0
2014-09-25 09:30:00	SPY	ETF	199.04	199.05	197.87	198.05	16530559.0
2014-09-25 10:00:00	SPY	ETF	198.05	198.12	197.17	197.57	16122711.0
2014-09-25 10:30:00	SPY	ETF	197.5799	197.5799	196.66	197.19	16954958.0
2014-09-25 11:00:00	SPY	ETF	197.2	197.29	196.8	197.287	10043464.0
2014-09-25 11:30:00	SPY	ETF	197.28	197.295	196.76	196.81	7243530.0
2014-09-25 12:00:00	SPY	ETF	196.81	197.08	196.48	196.493	7112258.0
2014-09-25 12:30:00	SPY	ETF	196.499	196.8988	196.42	196.68	5184338.0
2014-09-25 13:00:00	SPY	ETF	196.66	196.94	196.46	196.89	5464661.0
2014-09-25 13:30:00	SPY	ETF	196.88	196.93	196.33	196.47	6789039.0
2014-09-25 14:00:00	SPY	ETF	196.46	196.65	196.32	196.58	6520456.0
2014-09-25 14:30:00	SPY	ETF	196.58	196.939	196.525	196.67	7052419.0
2014-09-25 15:00:00	SPY	ETF	196.67	196.77	196.41	196.5	7679804.0
2014-09-25 15:30:00	SPY	ETF	196.5	196.97	196.32	196.32	18918745.0
2014-09-25 16:00:00	SPY	ETF	196.31	196.959	196.25	196.65	7919998.0
2014-09-25 16:30:00	SPY	ETF	196.63	196.86	196.52	196.59	3379312.0
2014-09-25 17:00:00	SPY	ETF	196.6	196.67	196.58	196.66	591427.0
2014-09-25 17:30:00	SPY	ETF	196.62	196.67	196.56	196.56	33762.0
2014-09-25 18:00:00	SPY	ETF	196.6	196.75	196.6	196.71	56194.0
2014-09-25 18:30:00	SPY	ETF	196.71	196.75	196.69	196.73	36119.0
2014-09-25 19:00:00	SPY	ETF	196.73	196.81	196.72	196.77	65263.0
2014-09-25 19:30:00	SPY	ETF	196.77	196.86	196.77	196.84	121059.0
2014-09-25 04:30:00	QQQ	ETF	99.85	99.85	99.85	99.85	5000.0
2014-09-25 05:30:00	QQQ	ETF	99.8	99.82	99.8	99.81	7600.0
2014-09-25 06:00:00	QQQ	ETF	99.77	99.77	99.75	99.75	1800.0
2014-09-25 06:30:00	QQQ	ETF	99.79	99.83	99.79	99.83	700.0
2014-09-25 07:00:00	QQQ	ETF	99.8	99.81	99.78	99.81	2800.0
2014-09-25 07:30:00	QQQ	ETF	99.81	99.85	99.8	99.8	7359.0
2014-09-25 08:00:00	QQQ	ETF	99.84	99.84	99.63	99.63	84073.0
2014-09-25 08:30:00	QQQ	ETF	99.65	99.7	99.5	99.55	275135.0
2014-09-25 09:00:00	QQQ	ETF	99.53	99.57	99.48	99.53	192220.0
2014-09-25 09:30:00	QQQ	ETF	99.53	99.65	98.74	98.84	6943022.0
2014-09-25 10:00:00	QQQ	ETF	98.85	98.9	98.19	98.42	6169153.0
2014-09-25 10:30:00	QQQ	ETF	98.42	98.42	97.981	98.2699	6221315.0
2014-09-25 11:00:00	QQQ	ETF	98.27	98.27	97.98	98.2	5965505.0
2014-09-25 11:30:00	QQQ	ETF	98.19	98.24	97.93	97.95	4810167.0
2014-09-25 12:00:00	QQQ	ETF	97.96	98.16	97.79	97.8101	4389805.0
2014-09-25 12:30:00	QQQ	ETF	97.81	98.0577	97.79	97.94	2852289.0
2014-09-25 13:00:00	QQQ	ETF	97.93	98.15	97.82	98.05	2599199.0
2014-09-25 13:30:00	QQQ	ETF	98.05	98.075	97.72	97.83	2951713.0

> showing 50 of 12,146 rows — these rows as CSV

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