PREVIEW / etf_30min / 2014-01-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-24.parquet
  size:    379 KB
  rows:    12,475

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-01-24 04:00:00	SPY	ETF	182.82	182.82	182.15	182.15	117799.0
2014-01-24 04:30:00	SPY	ETF	182.15	182.32	182.1	182.22	11478.0
2014-01-24 05:00:00	SPY	ETF	182.07	182.17	181.87	181.88	32387.0
2014-01-24 05:30:00	SPY	ETF	181.88	181.95	181.68	181.68	41866.0
2014-01-24 06:00:00	SPY	ETF	181.61	181.68	181.25	181.36	111995.0
2014-01-24 06:30:00	SPY	ETF	181.36	181.78	181.32	181.78	159403.0
2014-01-24 07:00:00	SPY	ETF	181.79	181.8	181.44	181.54	356234.0
2014-01-24 07:30:00	SPY	ETF	181.58	181.82	181.53	181.63	224160.0
2014-01-24 08:00:00	SPY	ETF	181.74	182.02	181.5	181.95	677744.0
2014-01-24 08:30:00	SPY	ETF	181.95	182.02	181.8	181.84	779928.0
2014-01-24 09:00:00	SPY	ETF	181.81	181.82	181.56	181.59	1576366.0
2014-01-24 09:30:00	SPY	ETF	181.6	181.66	180.98	181.34	18550298.0
2014-01-24 10:00:00	SPY	ETF	181.34	181.56	180.96	181.25	16675316.0
2014-01-24 10:30:00	SPY	ETF	181.25	181.25	180.36	180.64	19510233.0
2014-01-24 11:00:00	SPY	ETF	180.65	180.82	179.92	179.98	16157533.0
2014-01-24 11:30:00	SPY	ETF	179.98	180.62	179.89	180.5765	12620535.0
2014-01-24 12:00:00	SPY	ETF	180.571	180.64	180.21	180.41	9343627.0
2014-01-24 12:30:00	SPY	ETF	180.4	181.59	180.09	180.36	8041224.0
2014-01-24 13:00:00	SPY	ETF	180.35	180.48	180.17	180.21	6183113.0
2014-01-24 13:30:00	SPY	ETF	180.21	180.3299	180.08	180.135	5646276.0
2014-01-24 14:00:00	SPY	ETF	180.135	180.14	179.5	179.6157	12527128.0
2014-01-24 14:30:00	SPY	ETF	179.61	179.9	179.6	179.69	6613356.0
2014-01-24 15:00:00	SPY	ETF	179.68	179.8	179.2	179.36	13281998.0
2014-01-24 15:30:00	SPY	ETF	179.36	179.99	178.87	178.89	32410269.0
2014-01-24 16:00:00	SPY	ETF	178.89	180.8	178.56	178.59	17500068.0
2014-01-24 16:30:00	SPY	ETF	178.59	182.7017	178.43	178.48	5781813.0
2014-01-24 17:00:00	SPY	ETF	178.48	182.7017	178.43	178.53	721644.0
2014-01-24 17:30:00	SPY	ETF	178.52	178.82	178.48	178.79	251411.0
2014-01-24 18:00:00	SPY	ETF	178.79	178.81	178.66	178.74	38929.0
2014-01-24 18:30:00	SPY	ETF	178.74	178.74	178.52	178.59	11115.0
2014-01-24 19:00:00	SPY	ETF	178.62	178.66	178.56	178.66	8316.0
2014-01-24 19:30:00	SPY	ETF	178.67	178.69	178.56	178.59	16968.0
2014-01-24 04:00:00	QQQ	ETF	88.35	88.35	88.35	88.35	2000.0
2014-01-24 04:30:00	QQQ	ETF	88.45	88.45	88.45	88.45	100.0
2014-01-24 05:00:00	QQQ	ETF	88.2	88.2	88.2	88.2	1000.0
2014-01-24 05:30:00	QQQ	ETF	88.16	88.2	88.12	88.12	8070.0
2014-01-24 06:00:00	QQQ	ETF	88.07	88.12	87.94	87.99	49911.0
2014-01-24 06:30:00	QQQ	ETF	87.96	88.02	87.89	88.02	14920.0
2014-01-24 07:00:00	QQQ	ETF	88.12	88.13	87.97	87.99	145677.0
2014-01-24 07:30:00	QQQ	ETF	88.05	88.19	88.05	88.1	34488.0
2014-01-24 08:00:00	QQQ	ETF	88.13	88.3	88.08	88.26	154452.0
2014-01-24 08:30:00	QQQ	ETF	88.26	88.31	88.2	88.21	196685.0
2014-01-24 09:00:00	QQQ	ETF	88.21	88.21	88.05	88.05	489828.0
2014-01-24 09:30:00	QQQ	ETF	88.06	88.18	87.65	87.81	6993556.0
2014-01-24 10:00:00	QQQ	ETF	87.81	87.98	87.75	87.88	3900385.0
2014-01-24 10:30:00	QQQ	ETF	87.88	87.88	87.41	87.63	6145637.0
2014-01-24 11:00:00	QQQ	ETF	87.62	87.68	87.1	87.15	6341861.0
2014-01-24 11:30:00	QQQ	ETF	87.15	87.54	87.09	87.53	3718649.0
2014-01-24 12:00:00	QQQ	ETF	87.53	87.595	87.37	87.51	2254777.0
2014-01-24 12:30:00	QQQ	ETF	87.51	87.57	87.34	87.47	1600071.0

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

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