PREVIEW / etf_30min / 2014-12-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-30.parquet
  size:    374 KB
  rows:    12,679

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-12-30 04:00:00	SPY	ETF	208.3	208.3	208.03	208.09	23826.0
2014-12-30 04:30:00	SPY	ETF	208.12	208.24	208.09	208.24	16495.0
2014-12-30 05:00:00	SPY	ETF	208.22	208.27	208.22	208.27	1900.0
2014-12-30 05:30:00	SPY	ETF	208.32	208.34	208.17	208.24	12705.0
2014-12-30 06:00:00	SPY	ETF	208.22	208.22	208.17	208.22	160500.0
2014-12-30 06:30:00	SPY	ETF	208.24	208.24	208.13	208.13	57536.0
2014-12-30 07:00:00	SPY	ETF	208.18	208.26	208.12	208.18	137042.0
2014-12-30 07:30:00	SPY	ETF	208.23	208.42	208.09	208.19	60316.0
2014-12-30 08:00:00	SPY	ETF	208.2	208.28	208.12	208.19	180387.0
2014-12-30 08:30:00	SPY	ETF	208.18	208.72	207.93	208.15	409332.0
2014-12-30 09:00:00	SPY	ETF	208.15	208.25	207.97	208.2	667418.0
2014-12-30 09:30:00	SPY	ETF	208.21	208.37	208.04	208.12	9656028.0
2014-12-30 10:00:00	SPY	ETF	208.13	208.145	207.77	207.95	5995738.0
2014-12-30 10:30:00	SPY	ETF	207.95	208.22	207.86	208.14	6246409.0
2014-12-30 11:00:00	SPY	ETF	208.15	208.21	207.87	208.1	7245785.0
2014-12-30 11:30:00	SPY	ETF	208.09	208.14	207.95	208.06	4325580.0
2014-12-30 12:00:00	SPY	ETF	208.05	208.14	207.9	208.0	2974624.0
2014-12-30 12:30:00	SPY	ETF	207.99	208.03	207.8	207.901	2365208.0
2014-12-30 13:00:00	SPY	ETF	207.9	208.04	207.84	207.84	2064302.0
2014-12-30 13:30:00	SPY	ETF	207.84	207.92	207.51	207.59	5408909.0
2014-12-30 14:00:00	SPY	ETF	207.595	207.685	207.54	207.6499	3055671.0
2014-12-30 14:30:00	SPY	ETF	207.65	207.92	207.64	207.79	4168632.0
2014-12-30 15:00:00	SPY	ETF	207.79	207.915	207.745	207.84	3042114.0
2014-12-30 15:30:00	SPY	ETF	207.84	207.99	207.59	207.61	10776512.0
2014-12-30 16:00:00	SPY	ETF	207.6	207.89	207.54	207.85	3568359.0
2014-12-30 16:30:00	SPY	ETF	207.85	207.89	207.6	207.85	282308.0
2014-12-30 17:00:00	SPY	ETF	207.85	207.87	207.82	207.87	24365.0
2014-12-30 17:30:00	SPY	ETF	207.87	207.89	207.83	207.83	33130.0
2014-12-30 18:00:00	SPY	ETF	207.86	207.97	207.85	207.96	32711.0
2014-12-30 18:30:00	SPY	ETF	207.94	207.96	207.92	207.96	10500.0
2014-12-30 19:00:00	SPY	ETF	207.94	207.95	207.89	207.89	3525.0
2014-12-30 19:30:00	SPY	ETF	207.9	207.92	207.84	207.89	12400.0
2014-12-30 04:00:00	QQQ	ETF	104.85	104.86	104.85	104.86	4000.0
2014-12-30 05:30:00	QQQ	ETF	104.91	104.91	104.91	104.91	1000.0
2014-12-30 06:00:00	QQQ	ETF	104.89	104.92	104.88	104.88	5000.0
2014-12-30 06:30:00	QQQ	ETF	104.87	104.89	104.87	104.89	1000.0
2014-12-30 07:30:00	QQQ	ETF	104.98	105.01	104.86	104.86	17900.0
2014-12-30 08:00:00	QQQ	ETF	104.9	104.91	104.88	104.88	20324.0
2014-12-30 08:30:00	QQQ	ETF	104.86	105.02	104.72	104.75	40996.0
2014-12-30 09:00:00	QQQ	ETF	104.82	104.83	104.61	104.7	129376.0
2014-12-30 09:30:00	QQQ	ETF	104.72	104.96	104.61	104.6922	3724317.0
2014-12-30 10:00:00	QQQ	ETF	104.7	104.7	104.51	104.5999	1471974.0
2014-12-30 10:30:00	QQQ	ETF	104.595	104.7	104.5	104.67	920542.0
2014-12-30 11:00:00	QQQ	ETF	104.67	104.69	104.5335	104.67	1055932.0
2014-12-30 11:30:00	QQQ	ETF	104.66	104.68	104.6	104.62	517472.0
2014-12-30 12:00:00	QQQ	ETF	104.62	104.67	104.51	104.559	466238.0
2014-12-30 12:30:00	QQQ	ETF	104.5555	104.5599	104.37	104.45	766969.0
2014-12-30 13:00:00	QQQ	ETF	104.44	104.49	104.396	104.43	450985.0
2014-12-30 13:30:00	QQQ	ETF	104.42	104.48	104.21	104.236	842198.0
2014-12-30 14:00:00	QQQ	ETF	104.23	104.27	104.175	104.24	739497.0

> showing 50 of 12,679 rows — these rows as CSV

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