PREVIEW / etf_30min / 2013-01-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-17.parquet
  size:    308 KB
  rows:    10,415

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-01-17 04:00:00	SPY	ETF	146.85	147.03	146.85	147.03	5300.0
2013-01-17 05:00:00	SPY	ETF	146.91	146.91	146.91	146.91	180.0
2013-01-17 05:30:00	SPY	ETF	146.93	147.03	146.93	147.03	5300.0
2013-01-17 06:30:00	SPY	ETF	146.96	147.13	146.96	147.09	36376.0
2013-01-17 07:00:00	SPY	ETF	147.17	147.26	147.15	147.18	196028.0
2013-01-17 07:30:00	SPY	ETF	147.18	147.25	147.17	147.2	99218.0
2013-01-17 08:00:00	SPY	ETF	147.17	147.45	147.07	147.34	738539.0
2013-01-17 08:30:00	SPY	ETF	147.35	147.97	147.35	147.76	2350267.0
2013-01-17 09:00:00	SPY	ETF	147.76	147.82	147.05	147.69	1441589.0
2013-01-17 09:30:00	SPY	ETF	147.7	147.73	147.43	147.66	15300132.0
2013-01-17 10:00:00	SPY	ETF	147.66	147.86	147.23	147.84	14492779.0
2013-01-17 10:30:00	SPY	ETF	147.83	147.84	147.59	147.64	6265507.0
2013-01-17 11:00:00	SPY	ETF	147.65	147.81	147.63	147.8025	3861343.0
2013-01-17 11:30:00	SPY	ETF	147.81	147.96	147.79	147.805	5721175.0
2013-01-17 12:00:00	SPY	ETF	147.805	148.1	147.8	148.07	6030296.0
2013-01-17 12:30:00	SPY	ETF	148.0632	148.14	148.01	148.0385	5423001.0
2013-01-17 13:00:00	SPY	ETF	148.035	148.08	147.98	148.0101	6187349.0
2013-01-17 13:30:00	SPY	ETF	148.02	148.3	147.99	148.26	7711115.0
2013-01-17 14:00:00	SPY	ETF	148.26	148.4	148.24	148.3	7306190.0
2013-01-17 14:30:00	SPY	ETF	148.3	148.42	148.19	148.24	6213333.0
2013-01-17 15:00:00	SPY	ETF	148.24	148.29	148.11	148.19	6457528.0
2013-01-17 15:30:00	SPY	ETF	148.19	148.27	147.92	147.92	15242783.0
2013-01-17 16:00:00	SPY	ETF	147.93	148.33	147.1446	147.91	6413681.0
2013-01-17 16:30:00	SPY	ETF	147.96	148.1258	147.86	147.89	5637912.0
2013-01-17 17:00:00	SPY	ETF	147.89	147.94	147.88	147.93	6832967.0
2013-01-17 17:30:00	SPY	ETF	147.93	147.94	147.87	147.93	152423.0
2013-01-17 18:00:00	SPY	ETF	147.93	147.93	147.81	147.83	173164.0
2013-01-17 18:30:00	SPY	ETF	147.84	147.87	147.83	147.85	20073.0
2013-01-17 19:00:00	SPY	ETF	147.84	147.9	147.83	147.9	7653.0
2013-01-17 19:30:00	SPY	ETF	147.88	147.89	147.82	147.89	59555.0
2013-01-17 06:00:00	QQQ	ETF	66.93	66.93	66.93	66.93	1000.0
2013-01-17 06:30:00	QQQ	ETF	66.95	66.95	66.95	66.95	6000.0
2013-01-17 07:00:00	QQQ	ETF	67.0	67.04	67.0	67.01	5500.0
2013-01-17 07:30:00	QQQ	ETF	67.0	67.03	67.0	67.03	3400.0
2013-01-17 08:00:00	QQQ	ETF	67.02	67.14	67.01	67.09	14730.0
2013-01-17 08:30:00	QQQ	ETF	67.12	67.27	67.12	67.22	436199.0
2013-01-17 09:00:00	QQQ	ETF	67.21	67.21	67.16	67.19	139062.0
2013-01-17 09:30:00	QQQ	ETF	67.18	67.26	67.06	67.19	3271466.0
2013-01-17 10:00:00	QQQ	ETF	67.17	67.35	67.09	67.28	5758771.0
2013-01-17 10:30:00	QQQ	ETF	67.29	67.29	67.07	67.11	2690734.0
2013-01-17 11:00:00	QQQ	ETF	67.12	67.26	67.1	67.25	910178.0
2013-01-17 11:30:00	QQQ	ETF	67.25	67.3	67.18	67.18	1043930.0
2013-01-17 12:00:00	QQQ	ETF	67.18	67.3	67.18	67.29	788601.0
2013-01-17 12:30:00	QQQ	ETF	67.28	67.31	67.25	67.27	941604.0
2013-01-17 13:00:00	QQQ	ETF	67.27	67.29	67.2	67.28	971746.0
2013-01-17 13:30:00	QQQ	ETF	67.285	67.43	67.27	67.4	2030115.0
2013-01-17 14:00:00	QQQ	ETF	67.4	67.48	67.385	67.41	1276363.0
2013-01-17 14:30:00	QQQ	ETF	67.41	67.46	67.32	67.3484	1161288.0
2013-01-17 15:00:00	QQQ	ETF	67.34	67.36	67.23	67.29	1355071.0
2013-01-17 15:30:00	QQQ	ETF	67.29	67.365	67.22	67.23	6299742.0

> showing 50 of 10,415 rows — these rows as CSV

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