PREVIEW / etf_30min / 2013-06-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-11.parquet
  size:    333 KB
  rows:    11,164

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-06-11 04:00:00	SPY	ETF	164.8	164.8	164.19	164.24	9270.0
2013-06-11 04:30:00	SPY	ETF	164.19	164.19	164.14	164.19	5600.0
2013-06-11 05:00:00	SPY	ETF	164.23	164.23	163.9	163.91	31000.0
2013-06-11 05:30:00	SPY	ETF	163.9	163.9	163.34	163.49	80843.0
2013-06-11 06:00:00	SPY	ETF	163.47	163.54	163.35	163.52	130625.0
2013-06-11 06:30:00	SPY	ETF	163.54	163.58	163.3	163.39	221200.0
2013-06-11 07:00:00	SPY	ETF	163.37	163.42	163.15	163.25	337458.0
2013-06-11 07:30:00	SPY	ETF	163.23	163.55	163.19	163.25	665709.0
2013-06-11 08:00:00	SPY	ETF	163.32	163.51	163.13	163.16	2260559.0
2013-06-11 08:30:00	SPY	ETF	163.18	163.46	163.09	163.38	1056963.0
2013-06-11 09:00:00	SPY	ETF	163.36	163.42	163.13	163.25	1498966.0
2013-06-11 09:30:00	SPY	ETF	163.3	163.41	162.739	163.25	21274375.0
2013-06-11 10:00:00	SPY	ETF	163.25	163.55	163.0	163.44	12567563.0
2013-06-11 10:30:00	SPY	ETF	163.44	163.94	163.42	163.7999	9470330.0
2013-06-11 11:00:00	SPY	ETF	163.8	164.33	163.64	164.3	9882216.0
2013-06-11 11:30:00	SPY	ETF	164.3	164.54	164.2	164.23	9593828.0
2013-06-11 12:00:00	SPY	ETF	164.23	164.42	164.1	164.18	4985965.0
2013-06-11 12:30:00	SPY	ETF	164.185	164.3	164.04	164.13	4778217.0
2013-06-11 13:00:00	SPY	ETF	164.135	164.23	163.68	163.72	6795033.0
2013-06-11 13:30:00	SPY	ETF	163.7189	163.72	163.22	163.24	11893501.0
2013-06-11 14:00:00	SPY	ETF	163.23	163.69	163.14	163.68	9839860.0
2013-06-11 14:30:00	SPY	ETF	163.68	163.85	163.37	163.845	7329194.0
2013-06-11 15:00:00	SPY	ETF	163.84	163.95	163.52	163.5393	8488069.0
2013-06-11 15:30:00	SPY	ETF	163.54	163.5701	163.045	163.12	20479099.0
2013-06-11 16:00:00	SPY	ETF	163.12	164.7631	163.0981	163.31	11371894.0
2013-06-11 16:30:00	SPY	ETF	163.33	163.38	163.1696	163.34	679010.0
2013-06-11 17:00:00	SPY	ETF	163.35	163.41	163.32	163.35	163191.0
2013-06-11 17:30:00	SPY	ETF	163.33	163.33	163.3	163.32	32130.0
2013-06-11 18:00:00	SPY	ETF	163.33	163.39	163.26	163.29	30596.0
2013-06-11 18:30:00	SPY	ETF	163.25	163.3	163.21	163.26	57182.0
2013-06-11 19:00:00	SPY	ETF	163.26	163.3	163.26	163.27	4313.0
2013-06-11 19:30:00	SPY	ETF	163.3	163.4	163.28	163.38	33680.0
2013-06-11 04:00:00	QQQ	ETF	73.24	73.24	73.16	73.16	3200.0
2013-06-11 04:30:00	QQQ	ETF	73.14	73.18	73.14	73.18	1200.0
2013-06-11 05:00:00	QQQ	ETF	73.16	73.16	73.0	73.0	4600.0
2013-06-11 05:30:00	QQQ	ETF	72.98	72.98	72.74	72.76	6600.0
2013-06-11 06:00:00	QQQ	ETF	72.74	72.8	72.72	72.78	11338.0
2013-06-11 06:30:00	QQQ	ETF	72.76	72.76	72.72	72.75	3800.0
2013-06-11 07:00:00	QQQ	ETF	72.75	72.77	72.65	72.66	21582.0
2013-06-11 07:30:00	QQQ	ETF	72.66	72.79	72.64	72.72	146047.0
2013-06-11 08:00:00	QQQ	ETF	72.72	72.78	72.64	72.67	231085.0
2013-06-11 08:30:00	QQQ	ETF	72.66	72.74	72.63	72.72	224017.0
2013-06-11 09:00:00	QQQ	ETF	72.69	72.74	72.59	72.66	178872.0
2013-06-11 09:30:00	QQQ	ETF	72.67	72.8301	72.44	72.78	4946147.0
2013-06-11 10:00:00	QQQ	ETF	72.79	72.93	72.61	72.91	3796550.0
2013-06-11 10:30:00	QQQ	ETF	72.91	73.1	72.9	73.03	2527814.0
2013-06-11 11:00:00	QQQ	ETF	73.03	73.28	72.97	73.27	2552958.0
2013-06-11 11:30:00	QQQ	ETF	73.28	73.34	73.17	73.18	2199047.0
2013-06-11 12:00:00	QQQ	ETF	73.19	73.31	73.17	73.25	1944367.0
2013-06-11 12:30:00	QQQ	ETF	73.26	73.329	73.15	73.21	1746919.0

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

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