PREVIEW / etf_30min / 2014-02-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-18.parquet
  size:    344 KB
  rows:    11,726

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-02-18 04:00:00	SPY	ETF	184.08	184.08	183.99	184.05	21039.0
2014-02-18 04:30:00	SPY	ETF	184.02	184.03	183.77	183.81	5779.0
2014-02-18 05:00:00	SPY	ETF	183.85	183.93	183.79	183.93	3311.0
2014-02-18 05:30:00	SPY	ETF	183.93	183.93	183.88	183.89	2200.0
2014-02-18 06:00:00	SPY	ETF	183.84	183.88	183.73	183.78	16739.0
2014-02-18 06:30:00	SPY	ETF	183.73	183.93	183.73	183.88	24567.0
2014-02-18 07:00:00	SPY	ETF	183.9	184.23	183.9	184.21	198781.0
2014-02-18 07:30:00	SPY	ETF	184.24	184.32	184.18	184.27	101563.0
2014-02-18 08:00:00	SPY	ETF	184.0	184.32	183.85	184.15	772426.0
2014-02-18 08:30:00	SPY	ETF	184.13	184.15	183.87	184.03	620138.0
2014-02-18 09:00:00	SPY	ETF	184.03	184.25	184.03	184.19	655067.0
2014-02-18 09:30:00	SPY	ETF	184.19	184.46	183.9	184.04	11319454.0
2014-02-18 10:00:00	SPY	ETF	184.04	184.23	183.65	184.17	9014057.0
2014-02-18 10:30:00	SPY	ETF	184.18	184.28	184.11	184.1951	4613749.0
2014-02-18 11:00:00	SPY	ETF	184.2	184.46	184.12	184.45	4439558.0
2014-02-18 11:30:00	SPY	ETF	184.44	184.49	184.21	184.22	3555914.0
2014-02-18 12:00:00	SPY	ETF	184.22	184.39	184.18	184.32	2945009.0
2014-02-18 12:30:00	SPY	ETF	184.33	184.45	184.25	184.35	2556080.0
2014-02-18 13:00:00	SPY	ETF	184.35	184.4	184.29	184.325	1810355.0
2014-02-18 13:30:00	SPY	ETF	184.32	184.33	184.11	184.2401	3296605.0
2014-02-18 14:00:00	SPY	ETF	184.245	184.39	184.24	184.26	5943135.0
2014-02-18 14:30:00	SPY	ETF	184.27	184.48	184.24	184.35	3215056.0
2014-02-18 15:00:00	SPY	ETF	184.35	184.47	184.26	184.43	4175310.0
2014-02-18 15:30:00	SPY	ETF	184.44	184.46	184.2	184.25	12205066.0
2014-02-18 16:00:00	SPY	ETF	184.26	184.4	183.9814	184.22	5730072.0
2014-02-18 16:30:00	SPY	ETF	184.23	184.31	184.23	184.27	64693.0
2014-02-18 17:00:00	SPY	ETF	184.26	184.32	184.22	184.22	84039.0
2014-02-18 17:30:00	SPY	ETF	184.24	184.28	184.24	184.25	25535.0
2014-02-18 18:00:00	SPY	ETF	184.24	184.25	184.02	184.07	114707.0
2014-02-18 18:30:00	SPY	ETF	184.07	184.07	183.98	183.98	102130.0
2014-02-18 19:00:00	SPY	ETF	183.97	184.04	183.94	184.04	99735.0
2014-02-18 19:30:00	SPY	ETF	184.04	184.08	184.0	184.01	127821.0
2014-02-18 04:30:00	QQQ	ETF	89.8	89.8	89.8	89.8	300.0
2014-02-18 05:00:00	QQQ	ETF	89.79	89.79	89.79	89.79	1400.0
2014-02-18 05:30:00	QQQ	ETF	89.81	89.81	89.81	89.81	500.0
2014-02-18 06:00:00	QQQ	ETF	89.77	89.77	89.7	89.71	1300.0
2014-02-18 06:30:00	QQQ	ETF	89.75	89.78	89.75	89.78	2900.0
2014-02-18 07:00:00	QQQ	ETF	89.85	89.98	89.84	89.97	5800.0
2014-02-18 07:30:00	QQQ	ETF	89.97	89.98	89.92	89.96	10300.0
2014-02-18 08:00:00	QQQ	ETF	89.96	89.96	89.91	89.92	49815.0
2014-02-18 08:30:00	QQQ	ETF	89.91	89.95	89.83	89.9	91777.0
2014-02-18 09:00:00	QQQ	ETF	89.91	89.97	89.91	89.94	86565.0
2014-02-18 09:30:00	QQQ	ETF	89.93	90.19	89.86	89.92	3909788.0
2014-02-18 10:00:00	QQQ	ETF	89.91	90.2399	89.74	90.22	3757169.0
2014-02-18 10:30:00	QQQ	ETF	90.2299	90.34	90.1901	90.3	2045502.0
2014-02-18 11:00:00	QQQ	ETF	90.3	90.37	90.19	90.31	1351682.0
2014-02-18 11:30:00	QQQ	ETF	90.31	90.33	90.14	90.16	2147220.0
2014-02-18 12:00:00	QQQ	ETF	90.155	90.33	90.15	90.28	592258.0
2014-02-18 12:30:00	QQQ	ETF	90.29	90.35	90.23	90.27	1333822.0
2014-02-18 13:00:00	QQQ	ETF	90.265	90.3	90.24	90.27	446689.0

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

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