PREVIEW / etf_30min / 2013-09-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-26.parquet
  size:    308 KB
  rows:    10,480

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-26 04:00:00	SPY	ETF	169.33	169.47	169.33	169.34	12800.0
2013-09-26 04:30:00	SPY	ETF	169.32	169.36	169.26	169.34	3300.0
2013-09-26 05:00:00	SPY	ETF	169.32	169.36	169.26	169.36	4442.0
2013-09-26 05:30:00	SPY	ETF	169.34	169.36	169.3	169.34	1691.0
2013-09-26 06:00:00	SPY	ETF	169.32	169.32	169.15	169.15	64079.0
2013-09-26 06:30:00	SPY	ETF	169.14	169.21	169.12	169.21	5660.0
2013-09-26 07:00:00	SPY	ETF	169.21	169.35	169.21	169.3	92101.0
2013-09-26 07:30:00	SPY	ETF	169.34	169.44	169.3	169.36	92785.0
2013-09-26 08:00:00	SPY	ETF	169.34	169.8	169.21	169.4	228457.0
2013-09-26 08:30:00	SPY	ETF	169.36	169.53	169.15	169.45	826750.0
2013-09-26 09:00:00	SPY	ETF	169.44	169.44	169.28	169.31	468320.0
2013-09-26 09:30:00	SPY	ETF	169.32	169.93	169.32	169.9	8392996.0
2013-09-26 10:00:00	SPY	ETF	169.905	170.17	169.85	169.92	7517798.0
2013-09-26 10:30:00	SPY	ETF	169.93	170.03	169.3	169.43	8434395.0
2013-09-26 11:00:00	SPY	ETF	169.43	169.43	169.1	169.37	6437449.0
2013-09-26 11:30:00	SPY	ETF	169.36	169.52	169.29	169.44	3643832.0
2013-09-26 12:00:00	SPY	ETF	169.44	169.52	169.29	169.51	2020733.0
2013-09-26 12:30:00	SPY	ETF	169.505	169.68	169.46	169.55	2373147.0
2013-09-26 13:00:00	SPY	ETF	169.55	169.75	169.54	169.7	2119700.0
2013-09-26 13:30:00	SPY	ETF	169.7	169.75	169.34	169.48	2939176.0
2013-09-26 14:00:00	SPY	ETF	169.48	169.48	169.13	169.3305	3755348.0
2013-09-26 14:30:00	SPY	ETF	169.33	169.35	169.05	169.19	3313828.0
2013-09-26 15:00:00	SPY	ETF	169.18	169.32	169.06	169.2101	3941378.0
2013-09-26 15:30:00	SPY	ETF	169.215	169.69	169.16	169.65	12466052.0
2013-09-26 16:00:00	SPY	ETF	169.66	169.7792	169.06	169.75	4792046.0
2013-09-26 16:30:00	SPY	ETF	169.74	169.87	169.06	169.83	805648.0
2013-09-26 17:00:00	SPY	ETF	169.81	169.9	169.5005	169.88	318220.0
2013-09-26 17:30:00	SPY	ETF	169.86	169.92	169.86	169.88	26680.0
2013-09-26 18:00:00	SPY	ETF	169.88	169.98	169.88	169.96	45573.0
2013-09-26 18:30:00	SPY	ETF	169.89	169.97	169.87	169.97	29354.0
2013-09-26 19:00:00	SPY	ETF	169.95	169.97	169.92	169.94	18017.0
2013-09-26 19:30:00	SPY	ETF	169.94	169.96	169.91	169.94	26942.0
2013-09-26 04:00:00	QQQ	ETF	78.85	78.88	78.81	78.81	21302.0
2013-09-26 04:30:00	QQQ	ETF	78.8	78.83	78.79	78.83	8000.0
2013-09-26 05:00:00	QQQ	ETF	78.82	78.84	78.79	78.83	11200.0
2013-09-26 05:30:00	QQQ	ETF	78.84	78.84	78.81	78.81	5400.0
2013-09-26 06:00:00	QQQ	ETF	78.8	78.8	78.73	78.73	7800.0
2013-09-26 06:30:00	QQQ	ETF	78.72	78.76	78.71	78.76	5500.0
2013-09-26 07:00:00	QQQ	ETF	78.77	78.85	78.77	78.85	22891.0
2013-09-26 07:30:00	QQQ	ETF	78.85	78.87	78.82	78.85	7630.0
2013-09-26 08:00:00	QQQ	ETF	78.84	78.86	78.79	78.85	25580.0
2013-09-26 08:30:00	QQQ	ETF	78.84	78.92	78.84	78.92	47070.0
2013-09-26 09:00:00	QQQ	ETF	78.91	78.93	78.84	78.88	80236.0
2013-09-26 09:30:00	QQQ	ETF	78.87	79.2	78.87	79.19	2308747.0
2013-09-26 10:00:00	QQQ	ETF	79.18	79.36	79.17	79.3099	1808212.0
2013-09-26 10:30:00	QQQ	ETF	79.31	79.35	79.01	79.04	2377821.0
2013-09-26 11:00:00	QQQ	ETF	79.04	79.04	78.85	79.0	1541864.0
2013-09-26 11:30:00	QQQ	ETF	78.99	79.1193	78.967	79.09	850621.0
2013-09-26 12:00:00	QQQ	ETF	79.1	79.16	79.03	79.16	622704.0
2013-09-26 12:30:00	QQQ	ETF	79.17	79.2399	79.16	79.2	659924.0

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

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