PREVIEW / etf_30min / 2014-09-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-04.parquet
  size:    354 KB
  rows:    11,805

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-04 04:00:00	SPY	ETF	200.45	200.55	200.45	200.55	3300.0
2014-09-04 04:30:00	SPY	ETF	200.4	200.4	200.4	200.4	100.0
2014-09-04 05:00:00	SPY	ETF	200.3	200.43	200.3	200.43	2735.0
2014-09-04 05:30:00	SPY	ETF	200.5	200.66	200.5	200.66	2550.0
2014-09-04 06:00:00	SPY	ETF	200.67	200.72	200.65	200.7	14800.0
2014-09-04 06:30:00	SPY	ETF	200.7	201.04	200.7	201.0	77667.0
2014-09-04 07:00:00	SPY	ETF	200.98	201.19	200.95	201.18	194272.0
2014-09-04 07:30:00	SPY	ETF	201.15	201.4	200.9	200.95	664633.0
2014-09-04 08:00:00	SPY	ETF	200.63	201.23	200.63	201.07	1125146.0
2014-09-04 08:30:00	SPY	ETF	201.05	201.36	200.05	200.94	5234265.0
2014-09-04 09:00:00	SPY	ETF	200.91	201.09	200.76	200.84	671248.0
2014-09-04 09:30:00	SPY	ETF	200.84	201.38	200.7	201.28	9700097.0
2014-09-04 10:00:00	SPY	ETF	201.29	201.56	201.18	201.395	5854907.0
2014-09-04 10:30:00	SPY	ETF	201.395	201.54	201.3	201.44	4234049.0
2014-09-04 11:00:00	SPY	ETF	201.44	201.58	201.13	201.14	4798570.0
2014-09-04 11:30:00	SPY	ETF	201.13	201.22	201.02	201.11	3548904.0
2014-09-04 12:00:00	SPY	ETF	201.11	201.22	200.91	200.9601	2561683.0
2014-09-04 12:30:00	SPY	ETF	200.96	201.08	200.88	200.99	3229071.0
2014-09-04 13:00:00	SPY	ETF	200.98	201.08	200.93	200.98	1525258.0
2014-09-04 13:30:00	SPY	ETF	200.97	201.03	200.82	200.83	1809281.0
2014-09-04 14:00:00	SPY	ETF	200.84	200.98	200.67	200.77	2467498.0
2014-09-04 14:30:00	SPY	ETF	200.76	200.76	200.11	200.2	6240938.0
2014-09-04 15:00:00	SPY	ETF	200.195	200.24	199.66	200.0	10570414.0
2014-09-04 15:30:00	SPY	ETF	199.99	200.23	199.79	200.22	12252599.0
2014-09-04 16:00:00	SPY	ETF	200.21	201.5	200.13	200.34	3999726.0
2014-09-04 16:30:00	SPY	ETF	200.33	200.6	200.33	200.54	231997.0
2014-09-04 17:00:00	SPY	ETF	200.54	200.56	200.46	200.46	3355452.0
2014-09-04 17:30:00	SPY	ETF	200.47	200.5	200.45	200.47	24390.0
2014-09-04 18:00:00	SPY	ETF	200.47	200.47	200.4	200.43	112656.0
2014-09-04 18:30:00	SPY	ETF	200.46	200.49	200.46	200.48	36950.0
2014-09-04 19:00:00	SPY	ETF	200.48	200.51	200.48	200.49	25615.0
2014-09-04 19:30:00	SPY	ETF	200.49	200.51	200.44	200.47	55485.0
2014-09-04 04:30:00	QQQ	ETF	99.3	99.3	99.24	99.24	10900.0
2014-09-04 05:00:00	QQQ	ETF	99.37	99.37	99.37	99.37	200.0
2014-09-04 05:30:00	QQQ	ETF	99.38	99.51	99.38	99.51	1000.0
2014-09-04 06:00:00	QQQ	ETF	99.54	99.54	99.54	99.54	5000.0
2014-09-04 06:30:00	QQQ	ETF	99.55	99.71	99.55	99.69	14550.0
2014-09-04 07:00:00	QQQ	ETF	99.76	99.82	99.72	99.8	18600.0
2014-09-04 07:30:00	QQQ	ETF	99.78	99.8	99.66	99.66	52850.0
2014-09-04 08:00:00	QQQ	ETF	99.78	99.79	99.67	99.77	42408.0
2014-09-04 08:30:00	QQQ	ETF	99.75	99.88	99.71	99.72	174770.0
2014-09-04 09:00:00	QQQ	ETF	99.74	99.83	99.68	99.73	239044.0
2014-09-04 09:30:00	QQQ	ETF	99.73	100.15	99.6	100.08	3971692.0
2014-09-04 10:00:00	QQQ	ETF	100.09	100.22	100.0167	100.17	2205459.0
2014-09-04 10:30:00	QQQ	ETF	100.17	100.21	100.08	100.12	1340656.0
2014-09-04 11:00:00	QQQ	ETF	100.12	100.2	99.93	99.93	1681202.0
2014-09-04 11:30:00	QQQ	ETF	99.94	100.0	99.88	99.92	909877.0
2014-09-04 12:00:00	QQQ	ETF	99.92	100.0	99.79	99.81	925031.0
2014-09-04 12:30:00	QQQ	ETF	99.81	99.9	99.76	99.8238	750962.0
2014-09-04 13:00:00	QQQ	ETF	99.82	99.9299	99.79	99.88	600545.0

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

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