PREVIEW / etf_30min / 2013-12-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-06.parquet
  size:    336 KB
  rows:    11,195

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-12-06 04:00:00	SPY	ETF	179.47	179.63	179.4	179.58	59015.0
2013-12-06 04:30:00	SPY	ETF	179.61	179.84	179.57	179.76	75600.0
2013-12-06 05:00:00	SPY	ETF	179.78	179.8	179.68	179.7	30909.0
2013-12-06 05:30:00	SPY	ETF	179.71	179.73	179.62	179.62	17746.0
2013-12-06 06:00:00	SPY	ETF	179.6	179.66	179.6	179.64	9550.0
2013-12-06 06:30:00	SPY	ETF	179.62	179.9	179.6	179.87	103110.0
2013-12-06 07:00:00	SPY	ETF	179.87	179.89	179.74	179.74	163286.0
2013-12-06 07:30:00	SPY	ETF	179.73	179.75	179.6	179.7	250671.0
2013-12-06 08:00:00	SPY	ETF	179.7	179.87	179.57	179.72	1052464.0
2013-12-06 08:30:00	SPY	ETF	179.69	180.93	179.14	180.65	9476226.0
2013-12-06 09:00:00	SPY	ETF	180.66	180.9	180.62	180.67	1703545.0
2013-12-06 09:30:00	SPY	ETF	180.67	180.8	180.36	180.545	17825092.0
2013-12-06 10:00:00	SPY	ETF	180.55	180.72	180.41	180.51	7848102.0
2013-12-06 10:30:00	SPY	ETF	180.51	180.55	180.15	180.358	8947418.0
2013-12-06 11:00:00	SPY	ETF	180.35	180.63	180.27	180.49	6590227.0
2013-12-06 11:30:00	SPY	ETF	180.49	180.77	180.49	180.74	7096993.0
2013-12-06 12:00:00	SPY	ETF	180.75	180.75	180.57	180.67	2505683.0
2013-12-06 12:30:00	SPY	ETF	180.67	180.97	180.64	180.94	5025370.0
2013-12-06 13:00:00	SPY	ETF	180.93	180.99	180.825	180.825	5256161.0
2013-12-06 13:30:00	SPY	ETF	180.83	181.11	180.81	180.999	7613555.0
2013-12-06 14:00:00	SPY	ETF	180.995	181.11	180.96	180.98	4180592.0
2013-12-06 14:30:00	SPY	ETF	180.99	181.03	180.87	180.945	3667518.0
2013-12-06 15:00:00	SPY	ETF	180.945	180.97	180.75	180.75	6254186.0
2013-12-06 15:30:00	SPY	ETF	180.75	181.02	180.6	180.93	16937828.0
2013-12-06 16:00:00	SPY	ETF	180.93	181.05	178.9884	181.0	10286304.0
2013-12-06 16:30:00	SPY	ETF	181.0	181.06	180.6427	181.05	1255518.0
2013-12-06 17:00:00	SPY	ETF	181.05	181.09	180.94	181.06	1676462.0
2013-12-06 17:30:00	SPY	ETF	181.08	181.1	181.06	181.1	14225.0
2013-12-06 18:00:00	SPY	ETF	181.1	181.1	181.07	181.08	7184.0
2013-12-06 18:30:00	SPY	ETF	181.08	181.1	181.01	181.01	18728.0
2013-12-06 19:00:00	SPY	ETF	181.02	181.12	181.02	181.1	50579.0
2013-12-06 19:30:00	SPY	ETF	181.09	181.23	181.09	181.17	56345.0
2013-12-06 20:00:00	SPY	ETF	181.17	181.17	181.17	181.17	200.0
2013-12-06 04:30:00	QQQ	ETF	85.65	85.78	85.65	85.77	21440.0
2013-12-06 05:00:00	QQQ	ETF	85.73	85.73	85.7	85.7	2200.0
2013-12-06 06:00:00	QQQ	ETF	85.67	85.69	85.67	85.69	1100.0
2013-12-06 06:30:00	QQQ	ETF	85.69	85.76	85.67	85.76	5000.0
2013-12-06 07:00:00	QQQ	ETF	85.75	85.75	85.72	85.73	2500.0
2013-12-06 07:30:00	QQQ	ETF	85.7	85.7	85.66	85.69	77600.0
2013-12-06 08:00:00	QQQ	ETF	85.69	85.73	85.64	85.67	284058.0
2013-12-06 08:30:00	QQQ	ETF	85.7	86.15	85.45	86.07	1858177.0
2013-12-06 09:00:00	QQQ	ETF	86.08	86.15	86.06	86.09	735431.0
2013-12-06 09:30:00	QQQ	ETF	86.1	86.16	85.88	85.99	6174685.0
2013-12-06 10:00:00	QQQ	ETF	86.0	86.07	85.7601	85.79	2481992.0
2013-12-06 10:30:00	QQQ	ETF	85.79	85.81	85.59	85.775	3710109.0
2013-12-06 11:00:00	QQQ	ETF	85.77	85.94	85.73	85.91	2328254.0
2013-12-06 11:30:00	QQQ	ETF	85.92	86.09	85.92	86.075	1874750.0
2013-12-06 12:00:00	QQQ	ETF	86.075	86.11	86.03	86.07	1124773.0
2013-12-06 12:30:00	QQQ	ETF	86.07	86.18	86.05	86.15	1426977.0
2013-12-06 13:00:00	QQQ	ETF	86.14	86.17	86.01	86.021	847159.0

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

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