PREVIEW / etf_30min / 2014-09-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-05.parquet
  size:    341 KB
  rows:    11,378

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-05 04:00:00	SPY	ETF	200.03	200.06	199.95	200.0	11629.0
2014-09-05 04:30:00	SPY	ETF	199.97	200.07	199.92	199.95	17282.0
2014-09-05 05:00:00	SPY	ETF	199.88	199.9	199.85	199.89	12482.0
2014-09-05 05:30:00	SPY	ETF	199.94	199.97	199.69	199.69	9978.0
2014-09-05 06:00:00	SPY	ETF	199.67	199.71	199.48	199.69	71769.0
2014-09-05 06:30:00	SPY	ETF	199.64	199.7	199.53	199.7	196333.0
2014-09-05 07:00:00	SPY	ETF	199.7	199.8	199.64	199.68	275196.0
2014-09-05 07:30:00	SPY	ETF	199.67	199.76	199.56	199.75	79017.0
2014-09-05 08:00:00	SPY	ETF	199.62	199.8	199.5	199.64	596343.0
2014-09-05 08:30:00	SPY	ETF	199.61	200.5	199.34	199.99	4535146.0
2014-09-05 09:00:00	SPY	ETF	200.0	200.22	199.71	200.17	1726266.0
2014-09-05 09:30:00	SPY	ETF	200.17	200.3	199.56	200.17	11782202.0
2014-09-05 10:00:00	SPY	ETF	200.18	200.25	199.66	199.8	6038349.0
2014-09-05 10:30:00	SPY	ETF	199.795	199.88	199.41	199.78	7086116.0
2014-09-05 11:00:00	SPY	ETF	199.79	200.11	199.735	200.03	4065690.0
2014-09-05 11:30:00	SPY	ETF	200.03	200.36	199.94	200.265	3946547.0
2014-09-05 12:00:00	SPY	ETF	200.265	200.5	200.22	200.48	3124010.0
2014-09-05 12:30:00	SPY	ETF	200.48	200.77	200.48	200.665	5343220.0
2014-09-05 13:00:00	SPY	ETF	200.67	200.89	200.61	200.73	4111343.0
2014-09-05 13:30:00	SPY	ETF	200.73	200.775	200.57	200.72	2807511.0
2014-09-05 14:00:00	SPY	ETF	200.72	201.0	200.71	200.925	6371579.0
2014-09-05 14:30:00	SPY	ETF	200.92	200.96	200.73	200.86	3741413.0
2014-09-05 15:00:00	SPY	ETF	200.87	200.99	200.8	200.84	4156667.0
2014-09-05 15:30:00	SPY	ETF	200.845	201.19	200.82	201.13	15865194.0
2014-09-05 16:00:00	SPY	ETF	201.13	201.2156	199.77	201.12	9118954.0
2014-09-05 16:30:00	SPY	ETF	201.12	201.28	201.12	201.25	2587470.0
2014-09-05 17:00:00	SPY	ETF	201.26	201.32	201.15	201.2	109628.0
2014-09-05 17:30:00	SPY	ETF	201.2	201.27	201.17	201.27	14594.0
2014-09-05 18:00:00	SPY	ETF	201.27	201.27	201.21	201.24	8175.0
2014-09-05 18:30:00	SPY	ETF	201.21	201.23	201.21	201.23	2000.0
2014-09-05 19:00:00	SPY	ETF	201.24	201.25	201.21	201.25	7678.0
2014-09-05 19:30:00	SPY	ETF	201.24	201.29	201.24	201.29	11230.0
2014-09-05 04:00:00	QQQ	ETF	99.39	99.39	99.39	99.39	2662.0
2014-09-05 04:30:00	QQQ	ETF	99.26	99.26	99.26	99.26	100.0
2014-09-05 05:00:00	QQQ	ETF	99.3	99.31	99.3	99.31	21000.0
2014-09-05 05:30:00	QQQ	ETF	99.34	99.34	99.23	99.23	43200.0
2014-09-05 06:00:00	QQQ	ETF	99.18	99.23	99.12	99.23	66500.0
2014-09-05 06:30:00	QQQ	ETF	99.2	99.25	99.15	99.21	14200.0
2014-09-05 07:00:00	QQQ	ETF	99.26	99.33	99.25	99.3	27000.0
2014-09-05 07:30:00	QQQ	ETF	99.26	99.35	99.26	99.34	11800.0
2014-09-05 08:00:00	QQQ	ETF	99.33	99.36	99.26	99.28	84159.0
2014-09-05 08:30:00	QQQ	ETF	99.31	99.7	99.2	99.52	502062.0
2014-09-05 09:00:00	QQQ	ETF	99.52	99.63	99.39	99.57	411149.0
2014-09-05 09:30:00	QQQ	ETF	99.58	99.58	99.035	99.49	5933828.0
2014-09-05 10:00:00	QQQ	ETF	99.49	99.55	99.17	99.21	2696836.0
2014-09-05 10:30:00	QQQ	ETF	99.21	99.29	99.03	99.18	2747512.0
2014-09-05 11:00:00	QQQ	ETF	99.19	99.33	99.13	99.23	1538568.0
2014-09-05 11:30:00	QQQ	ETF	99.23	99.42	99.16	99.38	1219090.0
2014-09-05 12:00:00	QQQ	ETF	99.375	99.51	99.335	99.495	845454.0
2014-09-05 12:30:00	QQQ	ETF	99.5	99.64	99.4927	99.57	1181610.0

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

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