PREVIEW / etf_30min / 2013-07-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-05.parquet
  size:    314 KB
  rows:    10,749

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-05 04:00:00	SPY	ETF	162.85	163.0	161.99	162.84	39916.0
2013-07-05 04:30:00	SPY	ETF	162.83	162.9	162.78	162.84	3545.0
2013-07-05 05:00:00	SPY	ETF	162.85	162.89	162.79	162.79	8500.0
2013-07-05 05:30:00	SPY	ETF	162.84	162.84	162.79	162.84	1700.0
2013-07-05 06:00:00	SPY	ETF	162.79	162.9	162.76	162.89	32312.0
2013-07-05 06:30:00	SPY	ETF	162.84	162.86	162.74	162.82	50040.0
2013-07-05 07:00:00	SPY	ETF	162.75	162.79	162.56	162.62	107729.0
2013-07-05 07:30:00	SPY	ETF	162.64	162.69	162.5	162.62	290186.0
2013-07-05 08:00:00	SPY	ETF	162.59	163.3	162.58	162.85	1035396.0
2013-07-05 08:30:00	SPY	ETF	162.85	163.53	161.28	162.81	5791554.0
2013-07-05 09:00:00	SPY	ETF	162.8	162.8	162.08	162.47	4930109.0
2013-07-05 09:30:00	SPY	ETF	162.47	162.64	162.1	162.12	17343758.0
2013-07-05 10:00:00	SPY	ETF	162.115	162.34	161.3	161.59	13688083.0
2013-07-05 10:30:00	SPY	ETF	161.5901	161.93	161.4185	161.8901	7909049.0
2013-07-05 11:00:00	SPY	ETF	161.9	162.02	161.75	161.8	5251436.0
2013-07-05 11:30:00	SPY	ETF	161.8	162.33	161.55	162.3	5328219.0
2013-07-05 12:00:00	SPY	ETF	162.29	162.53	162.29	162.37	6025288.0
2013-07-05 12:30:00	SPY	ETF	162.3699	162.53	162.26	162.4	3602508.0
2013-07-05 13:00:00	SPY	ETF	162.41	162.56	162.17	162.345	5350041.0
2013-07-05 13:30:00	SPY	ETF	162.35	162.46	162.29	162.37	2621344.0
2013-07-05 14:00:00	SPY	ETF	162.38	162.81	162.38	162.79	5817438.0
2013-07-05 14:30:00	SPY	ETF	162.79	162.92	162.56	162.7	5539339.0
2013-07-05 15:00:00	SPY	ETF	162.7	162.72	162.22	162.37	5653274.0
2013-07-05 15:30:00	SPY	ETF	162.37	163.08	162.35	163.0	14351806.0
2013-07-05 16:00:00	SPY	ETF	163.0	163.26	161.3907	163.25	8889067.0
2013-07-05 16:30:00	SPY	ETF	163.26	163.36	163.26	163.33	772039.0
2013-07-05 17:00:00	SPY	ETF	163.34	163.36	163.23	163.32	611886.0
2013-07-05 17:30:00	SPY	ETF	163.32	163.37	163.29	163.32	68374.0
2013-07-05 18:00:00	SPY	ETF	163.32	163.32	163.21	163.21	37862.0
2013-07-05 18:30:00	SPY	ETF	163.24	163.32	163.2	163.27	13197.0
2013-07-05 19:00:00	SPY	ETF	163.24	163.34	163.24	163.34	6000.0
2013-07-05 19:30:00	SPY	ETF	163.31	163.4	163.28	163.37	9521.0
2013-07-05 04:00:00	QQQ	ETF	72.7	72.83	72.7	72.76	25419.0
2013-07-05 04:30:00	QQQ	ETF	72.78	72.78	72.74	72.76	2400.0
2013-07-05 05:00:00	QQQ	ETF	72.74	72.74	72.72	72.72	1200.0
2013-07-05 05:30:00	QQQ	ETF	72.74	72.74	72.74	72.74	584.0
2013-07-05 06:00:00	QQQ	ETF	72.73	72.81	72.73	72.79	5200.0
2013-07-05 06:30:00	QQQ	ETF	72.76	72.76	72.74	72.74	1539.0
2013-07-05 07:00:00	QQQ	ETF	72.73	72.73	72.68	72.68	3580.0
2013-07-05 07:30:00	QQQ	ETF	72.7	72.72	72.65	72.67	112950.0
2013-07-05 08:00:00	QQQ	ETF	72.65	72.72	72.56	72.66	147514.0
2013-07-05 08:30:00	QQQ	ETF	72.67	72.89	72.57	72.62	959094.0
2013-07-05 09:00:00	QQQ	ETF	72.62	72.62	72.32	72.45	596790.0
2013-07-05 09:30:00	QQQ	ETF	72.45	72.58	72.28	72.31	4233083.0
2013-07-05 10:00:00	QQQ	ETF	72.3	72.36	71.86	72.04	3957430.0
2013-07-05 10:30:00	QQQ	ETF	72.05	72.24	71.97	72.23	2022555.0
2013-07-05 11:00:00	QQQ	ETF	72.22	72.29	72.13	72.14	1220449.0
2013-07-05 11:30:00	QQQ	ETF	72.15	72.39	72.08	72.38	2031726.0
2013-07-05 12:00:00	QQQ	ETF	72.38	72.49	72.38	72.445	1630078.0
2013-07-05 12:30:00	QQQ	ETF	72.44	72.5	72.355	72.375	988496.0

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

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