PREVIEW / etf_30min / 2013-07-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-26.parquet
  size:    306 KB
  rows:    10,431

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-26 04:00:00	SPY	ETF	168.69	168.81	168.67	168.74	16700.0
2013-07-26 04:30:00	SPY	ETF	168.79	168.84	168.74	168.84	15033.0
2013-07-26 05:00:00	SPY	ETF	168.79	168.84	168.69	168.69	14500.0
2013-07-26 05:30:00	SPY	ETF	168.65	168.65	168.34	168.38	31350.0
2013-07-26 06:00:00	SPY	ETF	168.4	168.42	168.27	168.35	9200.0
2013-07-26 06:30:00	SPY	ETF	168.37	168.4	168.29	168.4	95620.0
2013-07-26 07:00:00	SPY	ETF	168.42	168.46	168.28	168.29	63626.0
2013-07-26 07:30:00	SPY	ETF	168.29	168.29	168.11	168.11	385152.0
2013-07-26 08:00:00	SPY	ETF	168.17	168.36	168.13	168.19	225293.0
2013-07-26 08:30:00	SPY	ETF	168.19	168.19	167.93	167.94	658193.0
2013-07-26 09:00:00	SPY	ETF	167.94	168.22	167.93	168.22	881838.0
2013-07-26 09:30:00	SPY	ETF	168.22	168.44	168.15	168.3999	10842409.0
2013-07-26 10:00:00	SPY	ETF	168.39	168.55	168.1	168.1	7335533.0
2013-07-26 10:30:00	SPY	ETF	168.11	168.19	167.52	167.655	10969802.0
2013-07-26 11:00:00	SPY	ETF	167.66	167.9	167.52	167.8	8475214.0
2013-07-26 11:30:00	SPY	ETF	167.8	168.11	167.78	168.0699	4791037.0
2013-07-26 12:00:00	SPY	ETF	168.07	168.3	168.07	168.271	5072339.0
2013-07-26 12:30:00	SPY	ETF	168.28	168.41	168.25	168.26	3565541.0
2013-07-26 13:00:00	SPY	ETF	168.26	168.68	168.26	168.61	4793386.0
2013-07-26 13:30:00	SPY	ETF	168.61	168.65	168.475	168.55	3685578.0
2013-07-26 14:00:00	SPY	ETF	168.549	168.78	168.38	168.41	4842684.0
2013-07-26 14:30:00	SPY	ETF	168.405	168.81	168.39	168.71	3754991.0
2013-07-26 15:00:00	SPY	ETF	168.72	168.96	168.62	168.86	5898994.0
2013-07-26 15:30:00	SPY	ETF	168.85	169.16	168.75	169.13	13526951.0
2013-07-26 16:00:00	SPY	ETF	169.13	169.22	168.6	169.11	10212776.0
2013-07-26 16:30:00	SPY	ETF	169.11	169.15	169.1	169.14	1072745.0
2013-07-26 17:00:00	SPY	ETF	169.14	169.26	169.12	169.26	166583.0
2013-07-26 17:30:00	SPY	ETF	169.25	169.28	169.22	169.27	100583.0
2013-07-26 18:00:00	SPY	ETF	169.25	169.26	169.19	169.24	5681.0
2013-07-26 18:30:00	SPY	ETF	169.2	169.24	169.08	169.17	36805.0
2013-07-26 19:00:00	SPY	ETF	169.17	169.19	169.11	169.15	8755.0
2013-07-26 19:30:00	SPY	ETF	169.19	169.21	169.11	169.12	12857.0
2013-07-26 04:00:00	QQQ	ETF	74.84	74.86	74.81	74.86	10400.0
2013-07-26 04:30:00	QQQ	ETF	74.84	74.88	74.84	74.86	6000.0
2013-07-26 05:00:00	QQQ	ETF	74.88	74.88	74.82	74.82	4000.0
2013-07-26 05:30:00	QQQ	ETF	74.8	74.8	74.66	74.66	9215.0
2013-07-26 06:00:00	QQQ	ETF	74.67	74.67	74.64	74.64	8700.0
2013-07-26 06:30:00	QQQ	ETF	74.66	74.68	74.66	74.68	2000.0
2013-07-26 07:00:00	QQQ	ETF	74.7	74.73	74.7	74.7	25200.0
2013-07-26 07:30:00	QQQ	ETF	74.68	74.69	74.67	74.68	56900.0
2013-07-26 08:00:00	QQQ	ETF	74.7	74.75	74.67	74.75	14800.0
2013-07-26 08:30:00	QQQ	ETF	74.72	74.73	74.6	74.61	43353.0
2013-07-26 09:00:00	QQQ	ETF	74.6	74.71	74.6	74.68	74832.0
2013-07-26 09:30:00	QQQ	ETF	74.67	74.93	74.57	74.9	2450450.0
2013-07-26 10:00:00	QQQ	ETF	74.9	74.93	74.8	74.83	1646403.0
2013-07-26 10:30:00	QQQ	ETF	74.84	74.94	74.55	74.6799	2290054.0
2013-07-26 11:00:00	QQQ	ETF	74.67	74.84	74.61	74.84	750427.0
2013-07-26 11:30:00	QQQ	ETF	74.84	74.96	74.83	74.93	1168657.0
2013-07-26 12:00:00	QQQ	ETF	74.93	75.02	74.92	75.02	1312472.0
2013-07-26 12:30:00	QQQ	ETF	75.02	75.06	74.995	74.995	575187.0

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

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