PREVIEW / etf_30min / 2013-09-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-16.parquet
  size:    339 KB
  rows:    11,391

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-09-16 04:00:00	SPY	ETF	171.0	171.4	170.66	171.39	97545.0
2013-09-16 04:30:00	SPY	ETF	171.39	171.39	171.25	171.25	13950.0
2013-09-16 05:00:00	SPY	ETF	171.26	171.31	171.19	171.31	3587.0
2013-09-16 05:30:00	SPY	ETF	171.28	171.3	171.13	171.19	3820.0
2013-09-16 06:00:00	SPY	ETF	171.21	171.34	171.2	171.28	52371.0
2013-09-16 06:30:00	SPY	ETF	171.25	171.28	171.2	171.22	106192.0
2013-09-16 07:00:00	SPY	ETF	171.22	171.22	171.09	171.19	96353.0
2013-09-16 07:30:00	SPY	ETF	171.18	171.2	171.13	171.17	232351.0
2013-09-16 08:00:00	SPY	ETF	171.17	171.22	171.01	171.07	519563.0
2013-09-16 08:30:00	SPY	ETF	171.05	171.61	170.97	171.01	848224.0
2013-09-16 09:00:00	SPY	ETF	171.0	171.2	171.0	171.16	1016029.0
2013-09-16 09:30:00	SPY	ETF	171.16	171.24	170.57	170.68	16995256.0
2013-09-16 10:00:00	SPY	ETF	170.68	170.82	170.4	170.74	9378072.0
2013-09-16 10:30:00	SPY	ETF	170.74	170.88	170.61	170.65	7392080.0
2013-09-16 11:00:00	SPY	ETF	170.65	170.85	170.58	170.84	4751233.0
2013-09-16 11:30:00	SPY	ETF	170.83	170.945	170.79	170.91	3998899.0
2013-09-16 12:00:00	SPY	ETF	170.91	171.06	170.87	170.981	4757328.0
2013-09-16 12:30:00	SPY	ETF	170.981	170.99	170.72	170.73	4179710.0
2013-09-16 13:00:00	SPY	ETF	170.73	170.82	170.66	170.71	9736541.0
2013-09-16 13:30:00	SPY	ETF	170.71	170.74	170.22	170.53	5636921.0
2013-09-16 14:00:00	SPY	ETF	170.52	170.56	170.34	170.37	3881196.0
2013-09-16 14:30:00	SPY	ETF	170.365	170.42	170.15	170.22	5914049.0
2013-09-16 15:00:00	SPY	ETF	170.22	170.48	170.21	170.24	5069868.0
2013-09-16 15:30:00	SPY	ETF	170.25	170.34	170.04	170.31	14014787.0
2013-09-16 16:00:00	SPY	ETF	170.32	170.89	169.3357	170.36	18477307.0
2013-09-16 16:30:00	SPY	ETF	170.37	170.45	170.34	170.35	1181600.0
2013-09-16 17:00:00	SPY	ETF	170.34	170.5538	170.17	170.21	416857.0
2013-09-16 17:30:00	SPY	ETF	170.22	170.23	170.19	170.19	45808.0
2013-09-16 18:00:00	SPY	ETF	170.18	170.31	170.18	170.3	39886.0
2013-09-16 18:30:00	SPY	ETF	170.31	170.31	170.26	170.3	2500.0
2013-09-16 19:00:00	SPY	ETF	170.29	170.31	170.27	170.31	8200.0
2013-09-16 19:30:00	SPY	ETF	170.27	170.27	170.15	170.18	24664.0
2013-09-16 04:00:00	QQQ	ETF	78.55	78.9	78.16	78.85	58265.0
2013-09-16 04:30:00	QQQ	ETF	78.87	78.87	78.83	78.83	11700.0
2013-09-16 05:30:00	QQQ	ETF	78.82	78.82	78.82	78.82	600.0
2013-09-16 06:00:00	QQQ	ETF	78.83	78.83	78.83	78.83	1000.0
2013-09-16 06:30:00	QQQ	ETF	78.8	78.8	78.78	78.8	3600.0
2013-09-16 07:00:00	QQQ	ETF	78.81	78.81	78.77	78.79	13865.0
2013-09-16 07:30:00	QQQ	ETF	78.79	78.8	78.78	78.8	16100.0
2013-09-16 08:00:00	QQQ	ETF	78.78	78.81	78.66	78.66	133009.0
2013-09-16 08:30:00	QQQ	ETF	78.68	78.68	78.57	78.6	203181.0
2013-09-16 09:00:00	QQQ	ETF	78.62	78.72	78.62	78.69	184988.0
2013-09-16 09:30:00	QQQ	ETF	78.69	78.72	78.27	78.32	4360763.0
2013-09-16 10:00:00	QQQ	ETF	78.31	78.36	78.18	78.25	2566192.0
2013-09-16 10:30:00	QQQ	ETF	78.24	78.3	78.1	78.17	2515596.0
2013-09-16 11:00:00	QQQ	ETF	78.17	78.26	78.11	78.25	1380949.0
2013-09-16 11:30:00	QQQ	ETF	78.25	78.3	78.22	78.24	679700.0
2013-09-16 12:00:00	QQQ	ETF	78.24	78.265	78.18	78.22	1102835.0
2013-09-16 12:30:00	QQQ	ETF	78.22	78.22	78.02	78.03	882269.0
2013-09-16 13:00:00	QQQ	ETF	78.03	78.16	78.03	78.11	814324.0

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

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