PREVIEW / etf_30min / 2012-02-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-27.parquet
  size:    288 KB
  rows:    9,751

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
2012-02-27 04:00:00	SPY	ETF	136.25	136.3	136.09	136.19	8612.0
2012-02-27 04:30:00	SPY	ETF	136.18	136.21	136.18	136.21	1400.0
2012-02-27 05:00:00	SPY	ETF	136.15	136.24	136.12	136.14	37550.0
2012-02-27 05:30:00	SPY	ETF	136.15	136.19	136.1	136.19	23800.0
2012-02-27 06:00:00	SPY	ETF	136.09	136.14	136.03	136.09	19225.0
2012-02-27 06:30:00	SPY	ETF	136.09	136.19	136.09	136.09	8440.0
2012-02-27 07:00:00	SPY	ETF	136.14	136.26	136.14	136.17	121632.0
2012-02-27 07:30:00	SPY	ETF	136.17	136.27	136.13	136.21	84679.0
2012-02-27 08:00:00	SPY	ETF	136.22	136.42	136.15	136.19	227737.0
2012-02-27 08:30:00	SPY	ETF	136.2	136.21	136.095	136.19	460662.0
2012-02-27 09:00:00	SPY	ETF	136.19	136.2	136.02	136.03	1046125.0
2012-02-27 09:30:00	SPY	ETF	136.02	136.13	135.8	136.08	18547415.0
2012-02-27 10:00:00	SPY	ETF	136.075	136.46	136.07	136.42	16007741.0
2012-02-27 10:30:00	SPY	ETF	136.42	136.82	136.35	136.68	14015497.0
2012-02-27 11:00:00	SPY	ETF	136.68	137.26	136.68	137.1	13331660.0
2012-02-27 11:30:00	SPY	ETF	137.105	137.17	136.97	137.11	11370325.0
2012-02-27 12:00:00	SPY	ETF	137.11	137.24	136.99	137.07	6890847.0
2012-02-27 12:30:00	SPY	ETF	137.07	137.46	137.01	137.2772	6591511.0
2012-02-27 13:00:00	SPY	ETF	137.28	137.31	137.15	137.15	2854435.0
2012-02-27 13:30:00	SPY	ETF	137.16	137.28	137.08	137.12	4456547.0
2012-02-27 14:00:00	SPY	ETF	137.12	137.25	137.11	137.17	2590469.0
2012-02-27 14:30:00	SPY	ETF	137.18	137.29	137.13	137.26	3800989.0
2012-02-27 15:00:00	SPY	ETF	137.27	137.53	137.14	137.25	12801953.0
2012-02-27 15:30:00	SPY	ETF	137.25	137.38	137.09	137.11	17478414.0
2012-02-27 16:00:00	SPY	ETF	137.13	137.29	137.0687	137.19	5575835.0
2012-02-27 16:30:00	SPY	ETF	137.2	137.2044	137.04	137.17	524587.0
2012-02-27 17:00:00	SPY	ETF	137.17	137.21	137.12	137.16	101846.0
2012-02-27 17:30:00	SPY	ETF	137.16	137.19	136.8842	137.09	4450396.0
2012-02-27 18:00:00	SPY	ETF	137.09	137.25	137.09	137.22	93701.0
2012-02-27 18:30:00	SPY	ETF	137.22	137.25	137.22	137.23	36075.0
2012-02-27 19:00:00	SPY	ETF	137.22	137.3	137.22	137.25	30635.0
2012-02-27 19:30:00	SPY	ETF	137.26	137.26	137.14	137.18	48604.0
2012-02-27 04:00:00	QQQ	ETF	63.62	63.62	63.62	63.62	200.0
2012-02-27 06:00:00	QQQ	ETF	63.62	63.62	63.61	63.61	2000.0
2012-02-27 06:30:00	QQQ	ETF	63.59	63.64	63.59	63.62	1210.0
2012-02-27 07:00:00	QQQ	ETF	63.62	63.64	63.6	63.62	35400.0
2012-02-27 07:30:00	QQQ	ETF	63.6	63.65	63.6	63.63	14940.0
2012-02-27 08:00:00	QQQ	ETF	63.64	63.68	63.62	63.64	264193.0
2012-02-27 08:30:00	QQQ	ETF	63.64	63.65	63.6	63.64	53352.0
2012-02-27 09:00:00	QQQ	ETF	63.65	63.65	63.58	63.6	412182.0
2012-02-27 09:30:00	QQQ	ETF	63.6	63.62	63.33	63.5	6945915.0
2012-02-27 10:00:00	QQQ	ETF	63.5	63.81	63.5	63.77	7076295.0
2012-02-27 10:30:00	QQQ	ETF	63.77	63.96	63.7084	63.88	3601420.0
2012-02-27 11:00:00	QQQ	ETF	63.87	64.18	63.87	64.11	4100853.0
2012-02-27 11:30:00	QQQ	ETF	64.1	64.13	64.01	64.07	2456978.0
2012-02-27 12:00:00	QQQ	ETF	64.0685	64.15	64.01	64.07	1486387.0
2012-02-27 12:30:00	QQQ	ETF	64.07	64.21	64.05	64.155	1713022.0
2012-02-27 13:00:00	QQQ	ETF	64.15	64.16	64.07	64.072	815676.0
2012-02-27 13:30:00	QQQ	ETF	64.075	64.11	63.98	63.99	1318442.0
2012-02-27 14:00:00	QQQ	ETF	63.99	64.12	63.99	64.088	960838.0

> showing 50 of 9,751 rows — these rows as CSV

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