PREVIEW / etf_30min / 2014-03-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-28.parquet
  size:    332 KB
  rows:    11,317

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-03-28 04:00:00	SPY	ETF	184.96	185.06	184.91	185.05	5125.0
2014-03-28 04:30:00	SPY	ETF	185.2	185.2	185.04	185.16	6416.0
2014-03-28 05:00:00	SPY	ETF	185.12	185.21	185.12	185.21	5742.0
2014-03-28 05:30:00	SPY	ETF	185.16	185.24	185.16	185.24	9320.0
2014-03-28 06:00:00	SPY	ETF	185.2	185.26	185.15	185.16	19153.0
2014-03-28 06:30:00	SPY	ETF	185.13	185.23	185.04	185.08	20502.0
2014-03-28 07:00:00	SPY	ETF	185.08	185.12	184.89	185.0	107920.0
2014-03-28 07:30:00	SPY	ETF	184.99	185.16	184.99	185.15	169309.0
2014-03-28 08:00:00	SPY	ETF	185.09	185.28	185.05	185.1	310993.0
2014-03-28 08:30:00	SPY	ETF	185.12	185.14	184.9	185.06	415104.0
2014-03-28 09:00:00	SPY	ETF	185.04	185.15	184.97	185.1	347488.0
2014-03-28 09:30:00	SPY	ETF	185.105	186.04	185.05	185.99	15523782.0
2014-03-28 10:00:00	SPY	ETF	185.98	186.28	185.91	186.03	9944054.0
2014-03-28 10:30:00	SPY	ETF	186.024	186.42	185.93	186.35	6024997.0
2014-03-28 11:00:00	SPY	ETF	186.36	186.39	186.13	186.14	5065710.0
2014-03-28 11:30:00	SPY	ETF	186.14	186.21	185.83	186.12	6193956.0
2014-03-28 12:00:00	SPY	ETF	186.11	186.22	185.97	186.0	4181010.0
2014-03-28 12:30:00	SPY	ETF	186.0	186.16	185.93	185.99	2286181.0
2014-03-28 13:00:00	SPY	ETF	185.99	186.02	185.57	185.75	5757648.0
2014-03-28 13:30:00	SPY	ETF	185.745	185.88	185.6	185.67	3730316.0
2014-03-28 14:00:00	SPY	ETF	185.665	185.67	185.0	185.36	7898241.0
2014-03-28 14:30:00	SPY	ETF	185.355	185.41	185.0	185.37	6391059.0
2014-03-28 15:00:00	SPY	ETF	185.365	185.46	185.09	185.32	5018661.0
2014-03-28 15:30:00	SPY	ETF	185.325	185.5	185.21	185.48	11189572.0
2014-03-28 16:00:00	SPY	ETF	185.48	185.6	184.6576	185.52	7245661.0
2014-03-28 16:30:00	SPY	ETF	185.53	185.57	185.49	185.52	912449.0
2014-03-28 17:00:00	SPY	ETF	185.51	185.71	185.49	185.64	709179.0
2014-03-28 17:30:00	SPY	ETF	185.64	185.79	185.62	185.76	180336.0
2014-03-28 18:00:00	SPY	ETF	185.73	185.75	185.63	185.65	50183.0
2014-03-28 18:30:00	SPY	ETF	185.65	185.66	185.6	185.65	42039.0
2014-03-28 19:00:00	SPY	ETF	185.64	185.72	185.64	185.7	9410.0
2014-03-28 19:30:00	SPY	ETF	185.7	185.79	185.65	185.76	13262.0
2014-03-28 04:00:00	QQQ	ETF	87.13	87.15	87.13	87.15	7500.0
2014-03-28 05:30:00	QQQ	ETF	87.29	87.32	87.28	87.32	700.0
2014-03-28 06:00:00	QQQ	ETF	87.32	87.33	87.27	87.27	10900.0
2014-03-28 06:30:00	QQQ	ETF	87.27	87.29	87.19	87.19	12500.0
2014-03-28 07:00:00	QQQ	ETF	87.23	87.23	87.12	87.13	22200.0
2014-03-28 07:30:00	QQQ	ETF	87.16	87.26	87.16	87.26	32300.0
2014-03-28 08:00:00	QQQ	ETF	87.26	87.33	87.2	87.21	55550.0
2014-03-28 08:30:00	QQQ	ETF	87.23	87.24	87.12	87.2	86933.0
2014-03-28 09:00:00	QQQ	ETF	87.2	87.23	87.14	87.15	101174.0
2014-03-28 09:30:00	QQQ	ETF	87.15	87.82	87.0399	87.7	7451214.0
2014-03-28 10:00:00	QQQ	ETF	87.7	87.902	87.68	87.76	4458278.0
2014-03-28 10:30:00	QQQ	ETF	87.76	88.01	87.7	87.94	2490000.0
2014-03-28 11:00:00	QQQ	ETF	87.94	87.94	87.741	87.81	1256298.0
2014-03-28 11:30:00	QQQ	ETF	87.8125	87.84	87.63	87.76	1780746.0
2014-03-28 12:00:00	QQQ	ETF	87.77	87.84	87.56	87.59	1603851.0
2014-03-28 12:30:00	QQQ	ETF	87.59	87.72	87.58	87.63	1394157.0
2014-03-28 13:00:00	QQQ	ETF	87.63	87.63	87.36	87.49	2239928.0
2014-03-28 13:30:00	QQQ	ETF	87.48	87.57	87.3299	87.36	1466495.0

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

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