PREVIEW / etf_30min / 2014-08-28

all etf 30-min files

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

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-08-28 04:00:00	SPY	ETF	200.0	200.0	199.93	199.93	1335.0
2014-08-28 04:30:00	SPY	ETF	199.96	200.01	199.94	199.99	23088.0
2014-08-28 05:00:00	SPY	ETF	200.02	200.04	199.97	199.99	57494.0
2014-08-28 05:30:00	SPY	ETF	200.0	200.02	199.45	199.62	97778.0
2014-08-28 06:00:00	SPY	ETF	199.56	199.64	199.4	199.55	102047.0
2014-08-28 06:30:00	SPY	ETF	199.53	199.65	199.35	199.52	122324.0
2014-08-28 07:00:00	SPY	ETF	199.53	199.89	199.5	199.81	164213.0
2014-08-28 07:30:00	SPY	ETF	199.8	199.84	199.53	199.57	181465.0
2014-08-28 08:00:00	SPY	ETF	199.93	199.96	199.36	199.59	703554.0
2014-08-28 08:30:00	SPY	ETF	199.6	199.84	199.51	199.6	549638.0
2014-08-28 09:00:00	SPY	ETF	199.59	199.6405	199.42	199.59	968032.0
2014-08-28 09:30:00	SPY	ETF	199.59	199.87	199.39	199.819	9522928.0
2014-08-28 10:00:00	SPY	ETF	199.82	199.92	199.51	199.8099	5155051.0
2014-08-28 10:30:00	SPY	ETF	199.805	200.02	199.66	199.96	5597655.0
2014-08-28 11:00:00	SPY	ETF	199.97	200.02	199.81	199.91	3465433.0
2014-08-28 11:30:00	SPY	ETF	199.92	200.04	199.87	199.99	3204887.0
2014-08-28 12:00:00	SPY	ETF	199.985	200.22	199.93	200.205	2303500.0
2014-08-28 12:30:00	SPY	ETF	200.205	200.27	200.12	200.19	1676107.0
2014-08-28 13:00:00	SPY	ETF	200.19	200.21	200.08	200.13	1426044.0
2014-08-28 13:30:00	SPY	ETF	200.1323	200.24	200.1	200.175	1433645.0
2014-08-28 14:00:00	SPY	ETF	200.17	200.21	200.09	200.17	2427231.0
2014-08-28 14:30:00	SPY	ETF	200.17	200.24	200.07	200.08	1531942.0
2014-08-28 15:00:00	SPY	ETF	200.08	200.18	200.02	200.125	2258358.0
2014-08-28 15:30:00	SPY	ETF	200.12	200.205	199.96	200.14	6089764.0
2014-08-28 16:00:00	SPY	ETF	200.14	200.3	200.0504	200.27	2526948.0
2014-08-28 16:30:00	SPY	ETF	200.28	200.45	200.0685	200.43	405525.0
2014-08-28 17:00:00	SPY	ETF	200.44	200.51	200.14	200.48	4779852.0
2014-08-28 17:30:00	SPY	ETF	200.48	200.48	200.45	200.46	26179.0
2014-08-28 18:00:00	SPY	ETF	200.46	200.47	200.38	200.4	52643.0
2014-08-28 18:30:00	SPY	ETF	200.43	200.43	200.4	200.4	3125.0
2014-08-28 19:00:00	SPY	ETF	200.41	200.42	200.4	200.4	19350.0
2014-08-28 19:30:00	SPY	ETF	200.41	200.44	200.41	200.42	78286.0
2014-08-28 04:00:00	QQQ	ETF	99.37	99.37	99.34	99.34	5000.0
2014-08-28 05:30:00	QQQ	ETF	99.37	99.37	99.14	99.21	51350.0
2014-08-28 06:00:00	QQQ	ETF	99.14	99.18	99.12	99.16	14905.0
2014-08-28 06:30:00	QQQ	ETF	99.16	99.23	99.1	99.17	6333.0
2014-08-28 07:00:00	QQQ	ETF	99.17	99.34	99.16	99.32	39300.0
2014-08-28 07:30:00	QQQ	ETF	99.29	99.3	99.22	99.22	24925.0
2014-08-28 08:00:00	QQQ	ETF	99.25	99.29	99.22	99.22	107939.0
2014-08-28 08:30:00	QQQ	ETF	99.22	99.33	99.19	99.22	124046.0
2014-08-28 09:00:00	QQQ	ETF	99.23	99.23	99.14	99.21	360985.0
2014-08-28 09:30:00	QQQ	ETF	99.2	99.33	99.08	99.28	3149370.0
2014-08-28 10:00:00	QQQ	ETF	99.285	99.33	99.16	99.24	1888804.0
2014-08-28 10:30:00	QQQ	ETF	99.24	99.4	99.1872	99.3472	2001247.0
2014-08-28 11:00:00	QQQ	ETF	99.35	99.39	99.2932	99.33	1133304.0
2014-08-28 11:30:00	QQQ	ETF	99.33	99.4	99.305	99.34	710537.0
2014-08-28 12:00:00	QQQ	ETF	99.3499	99.52	99.31	99.49	859973.0
2014-08-28 12:30:00	QQQ	ETF	99.5	99.53	99.44	99.46	504342.0
2014-08-28 13:00:00	QQQ	ETF	99.47	99.47	99.385	99.411	508761.0
2014-08-28 13:30:00	QQQ	ETF	99.4101	99.465	99.37	99.44	399728.0

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

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