PREVIEW / etf_30min / 2013-07-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-15.parquet
  size:    311 KB
  rows:    10,770

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-07-15 04:00:00	SPY	ETF	167.81	167.93	167.81	167.83	5776.0
2013-07-15 04:30:00	SPY	ETF	167.84	167.9	167.83	167.83	4300.0
2013-07-15 05:00:00	SPY	ETF	167.87	167.88	167.83	167.85	2700.0
2013-07-15 05:30:00	SPY	ETF	167.8	167.8	167.67	167.67	1700.0
2013-07-15 06:00:00	SPY	ETF	167.63	167.68	167.63	167.67	2200.0
2013-07-15 06:30:00	SPY	ETF	167.65	167.75	167.65	167.68	10195.0
2013-07-15 07:00:00	SPY	ETF	167.7	167.79	167.675	167.71	40455.0
2013-07-15 07:30:00	SPY	ETF	167.75	167.81	167.66	167.72	302650.0
2013-07-15 08:00:00	SPY	ETF	167.72	167.9	167.71	167.83	361471.0
2013-07-15 08:30:00	SPY	ETF	167.83	167.94	167.78	167.85	410476.0
2013-07-15 09:00:00	SPY	ETF	167.84	167.97	167.51	167.96	680949.0
2013-07-15 09:30:00	SPY	ETF	167.97	168.12	167.68	167.845	11907777.0
2013-07-15 10:00:00	SPY	ETF	167.85	168.04	167.77	167.93	5927526.0
2013-07-15 10:30:00	SPY	ETF	167.93	168.04	167.84	168.01	5189871.0
2013-07-15 11:00:00	SPY	ETF	168.0	168.08	167.91	168.07	4814549.0
2013-07-15 11:30:00	SPY	ETF	168.07	168.2	168.05	168.15	4601394.0
2013-07-15 12:00:00	SPY	ETF	168.14	168.23	168.1	168.21	2465399.0
2013-07-15 12:30:00	SPY	ETF	168.2	168.22	168.08	168.1	2240958.0
2013-07-15 13:00:00	SPY	ETF	168.1	168.16	168.01	168.13	2449461.0
2013-07-15 13:30:00	SPY	ETF	168.12	168.21	168.05	168.18	2653655.0
2013-07-15 14:00:00	SPY	ETF	168.18	168.33	168.16	168.31	4047834.0
2013-07-15 14:30:00	SPY	ETF	168.3	168.39	168.21	168.29	3926264.0
2013-07-15 15:00:00	SPY	ETF	168.29	168.34	168.19	168.211	3376735.0
2013-07-15 15:30:00	SPY	ETF	168.21	168.28	168.14	168.19	8651755.0
2013-07-15 16:00:00	SPY	ETF	168.18	168.3293	168.0088	168.23	3885158.0
2013-07-15 16:30:00	SPY	ETF	168.22	168.25	168.2	168.22	314943.0
2013-07-15 17:00:00	SPY	ETF	168.22	168.23	168.18	168.22	545030.0
2013-07-15 17:30:00	SPY	ETF	168.21	168.21	168.18	168.21	9870.0
2013-07-15 18:00:00	SPY	ETF	168.19	168.26	168.19	168.2	16835.0
2013-07-15 18:30:00	SPY	ETF	168.2	168.2	168.18	168.18	5370.0
2013-07-15 19:00:00	SPY	ETF	168.2	168.23	168.19	168.19	13455.0
2013-07-15 19:30:00	SPY	ETF	168.21	168.23	168.15	168.18	27103.0
2013-07-15 04:00:00	QQQ	ETF	75.37	75.37	75.35	75.37	3000.0
2013-07-15 04:30:00	QQQ	ETF	75.35	75.35	75.35	75.35	600.0
2013-07-15 05:00:00	QQQ	ETF	75.35	75.35	75.35	75.35	200.0
2013-07-15 05:30:00	QQQ	ETF	75.33	75.33	75.33	75.33	600.0
2013-07-15 06:30:00	QQQ	ETF	75.28	75.33	75.28	75.29	1000.0
2013-07-15 07:00:00	QQQ	ETF	75.3	75.33	75.28	75.33	5868.0
2013-07-15 07:30:00	QQQ	ETF	75.29	75.3	75.28	75.3	7400.0
2013-07-15 08:00:00	QQQ	ETF	75.29	75.32	75.29	75.32	25070.0
2013-07-15 08:30:00	QQQ	ETF	75.3	75.32	75.28	75.29	61048.0
2013-07-15 09:00:00	QQQ	ETF	75.28	75.36	75.28	75.36	119264.0
2013-07-15 09:30:00	QQQ	ETF	75.36	75.42	75.17	75.26	2476970.0
2013-07-15 10:00:00	QQQ	ETF	75.27	75.375	75.24	75.32	952000.0
2013-07-15 10:30:00	QQQ	ETF	75.32	75.385	75.29	75.385	1206768.0
2013-07-15 11:00:00	QQQ	ETF	75.39	75.42	75.33	75.42	800827.0
2013-07-15 11:30:00	QQQ	ETF	75.41	75.45	75.38	75.42	710580.0
2013-07-15 12:00:00	QQQ	ETF	75.42	75.46	75.37	75.4399	755961.0
2013-07-15 12:30:00	QQQ	ETF	75.4359	75.4443	75.38	75.4099	473205.0
2013-07-15 13:00:00	QQQ	ETF	75.41	75.44	75.379	75.41	569545.0

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

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