PREVIEW / etf_30min / 2014-03-05

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-05.parquet
  size:    322 KB
  rows:    11,243

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
2014-03-05 04:00:00	SPY	ETF	187.75	187.75	187.61	187.61	1989.0
2014-03-05 04:30:00	SPY	ETF	187.65	187.66	187.62	187.62	2145.0
2014-03-05 05:00:00	SPY	ETF	187.61	187.61	187.56	187.56	4624.0
2014-03-05 05:30:00	SPY	ETF	187.63	187.65	187.63	187.65	319.0
2014-03-05 06:00:00	SPY	ETF	187.55	187.57	187.55	187.57	3997.0
2014-03-05 06:30:00	SPY	ETF	187.58	187.72	187.51	187.67	9184.0
2014-03-05 07:00:00	SPY	ETF	187.62	187.76	187.58	187.75	142513.0
2014-03-05 07:30:00	SPY	ETF	187.74	187.97	187.74	187.92	365382.0
2014-03-05 08:00:00	SPY	ETF	187.86	188.17	187.63	187.79	801695.0
2014-03-05 08:30:00	SPY	ETF	187.78	187.82	187.66	187.7	326596.0
2014-03-05 09:00:00	SPY	ETF	187.71	187.78	187.62	187.74	859859.0
2014-03-05 09:30:00	SPY	ETF	187.72	187.9	187.45	187.606	12256899.0
2014-03-05 10:00:00	SPY	ETF	187.6	188.0	187.45	187.87	8962360.0
2014-03-05 10:30:00	SPY	ETF	187.88	187.96	187.58	187.79	5151277.0
2014-03-05 11:00:00	SPY	ETF	187.8	188.07	187.59	187.62	6289743.0
2014-03-05 11:30:00	SPY	ETF	187.62	187.9025	187.59	187.79	6514967.0
2014-03-05 12:00:00	SPY	ETF	187.79	187.83	187.58	187.6635	2864933.0
2014-03-05 12:30:00	SPY	ETF	187.66	187.8501	187.64	187.78	2317301.0
2014-03-05 13:00:00	SPY	ETF	187.78	188.0	187.78	187.869	3511194.0
2014-03-05 13:30:00	SPY	ETF	187.869	187.88	187.58	187.681	3528596.0
2014-03-05 14:00:00	SPY	ETF	187.69	187.87	187.62	187.6801	5020868.0
2014-03-05 14:30:00	SPY	ETF	187.68	187.78	187.599	187.65	3562310.0
2014-03-05 15:00:00	SPY	ETF	187.65	187.7	187.49	187.69	5285083.0
2014-03-05 15:30:00	SPY	ETF	187.685	187.82	187.55	187.73	7537661.0
2014-03-05 16:00:00	SPY	ETF	187.73	187.79	187.61	187.74	7919869.0
2014-03-05 16:30:00	SPY	ETF	187.73	187.86	187.61	187.8	2403997.0
2014-03-05 17:00:00	SPY	ETF	187.8	187.89	187.78	187.85	54162.0
2014-03-05 17:30:00	SPY	ETF	187.88	187.89	187.84	187.88	36900.0
2014-03-05 18:00:00	SPY	ETF	187.87	187.87	187.67	187.69	68446.0
2014-03-05 18:30:00	SPY	ETF	187.74	187.77	187.71	187.77	5150.0
2014-03-05 19:00:00	SPY	ETF	187.79	187.79	187.71	187.74	9190.0
2014-03-05 19:30:00	SPY	ETF	187.75	187.77	187.73	187.77	19800.0
2014-03-05 06:00:00	QQQ	ETF	90.81	90.82	90.8	90.82	3287.0
2014-03-05 07:00:00	QQQ	ETF	90.85	90.92	90.85	90.91	19413.0
2014-03-05 07:30:00	QQQ	ETF	90.92	91.01	90.92	90.97	73410.0
2014-03-05 08:00:00	QQQ	ETF	90.95	90.99	90.9	90.95	46055.0
2014-03-05 08:30:00	QQQ	ETF	90.93	90.96	90.89	90.92	87975.0
2014-03-05 09:00:00	QQQ	ETF	90.9	90.97	90.83	90.95	62469.0
2014-03-05 09:30:00	QQQ	ETF	90.965	91.03	90.84	90.88	4125906.0
2014-03-05 10:00:00	QQQ	ETF	90.88	91.12	90.77	91.061	1918045.0
2014-03-05 10:30:00	QQQ	ETF	91.07	91.12	90.9001	91.03	1368565.0
2014-03-05 11:00:00	QQQ	ETF	91.03	91.16	90.97	90.985	1248034.0
2014-03-05 11:30:00	QQQ	ETF	90.97	91.09	90.95	91.05	744381.0
2014-03-05 12:00:00	QQQ	ETF	91.05	91.0699	90.96	91.04	661275.0
2014-03-05 12:30:00	QQQ	ETF	91.04	91.16	91.03	91.12	762846.0
2014-03-05 13:00:00	QQQ	ETF	91.13	91.22	91.08	91.1	967731.0
2014-03-05 13:30:00	QQQ	ETF	91.11	91.115	91.01	91.05	1045350.0
2014-03-05 14:00:00	QQQ	ETF	91.05	91.14	91.0	91.04	1280010.0
2014-03-05 14:30:00	QQQ	ETF	91.04	91.09	90.98	91.03	1013267.0
2014-03-05 15:00:00	QQQ	ETF	91.03	91.05	90.95	91.0401	1026573.0

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

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