PREVIEW / etf_30min / 2014-02-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-06.parquet
  size:    343 KB
  rows:    11,403

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-06 04:00:00	SPY	ETF	175.26	175.39	175.25	175.34	1328.0
2014-02-06 04:30:00	SPY	ETF	175.38	175.9	175.38	175.85	20226.0
2014-02-06 05:00:00	SPY	ETF	175.79	176.07	175.79	175.85	52237.0
2014-02-06 05:30:00	SPY	ETF	175.93	175.95	175.81	175.81	180276.0
2014-02-06 06:00:00	SPY	ETF	175.78	175.9	175.74	175.8	7725.0
2014-02-06 06:30:00	SPY	ETF	175.81	175.81	175.71	175.75	64466.0
2014-02-06 07:00:00	SPY	ETF	175.73	175.78	175.38	175.44	313694.0
2014-02-06 07:30:00	SPY	ETF	175.42	175.62	174.97	175.4	724556.0
2014-02-06 08:00:00	SPY	ETF	175.4	175.9	175.33	175.9	665109.0
2014-02-06 08:30:00	SPY	ETF	175.9	176.01	174.96	175.36	3609470.0
2014-02-06 09:00:00	SPY	ETF	175.36	175.66	175.22	175.59	1542820.0
2014-02-06 09:30:00	SPY	ETF	175.58	176.47	175.58	176.42	14288310.0
2014-02-06 10:00:00	SPY	ETF	176.42	176.72	176.35	176.66	8897010.0
2014-02-06 10:30:00	SPY	ETF	176.65	177.135	176.65	176.92	13336443.0
2014-02-06 11:00:00	SPY	ETF	176.91	177.055	176.76	176.791	8561343.0
2014-02-06 11:30:00	SPY	ETF	176.795	177.18	175.2209	176.85	7684633.0
2014-02-06 12:00:00	SPY	ETF	176.855	177.12	176.855	177.055	4639204.0
2014-02-06 12:30:00	SPY	ETF	177.055	177.16	176.91	176.95	4141429.0
2014-02-06 13:00:00	SPY	ETF	176.95	177.05	176.67	176.75	4212108.0
2014-02-06 13:30:00	SPY	ETF	176.745	176.94	176.74	176.842	2870009.0
2014-02-06 14:00:00	SPY	ETF	176.845	177.4	176.84	177.31	11397504.0
2014-02-06 14:30:00	SPY	ETF	177.32	177.38	177.09	177.285	6476778.0
2014-02-06 15:00:00	SPY	ETF	177.29	177.39	177.19	177.285	7042077.0
2014-02-06 15:30:00	SPY	ETF	177.281	177.48	177.16	177.42	17294601.0
2014-02-06 16:00:00	SPY	ETF	177.42	177.48	177.0635	177.25	7537067.0
2014-02-06 16:30:00	SPY	ETF	177.25	177.404	175.2209	177.27	2146681.0
2014-02-06 17:00:00	SPY	ETF	177.31	177.34	177.25	177.28	2054615.0
2014-02-06 17:30:00	SPY	ETF	177.28	177.3	177.2	177.25	194490.0
2014-02-06 18:00:00	SPY	ETF	177.25	177.48	177.2	177.28	463599.0
2014-02-06 18:30:00	SPY	ETF	177.28	177.34	177.26	177.33	5156.0
2014-02-06 19:00:00	SPY	ETF	177.32	177.32	177.24	177.27	35846.0
2014-02-06 19:30:00	SPY	ETF	177.28	177.31	177.23	177.24	17527.0
2014-02-06 04:00:00	QQQ	ETF	84.75	84.75	84.75	84.75	200.0
2014-02-06 04:30:00	QQQ	ETF	84.89	84.97	84.89	84.97	3900.0
2014-02-06 05:00:00	QQQ	ETF	85.13	85.13	85.08	85.08	6400.0
2014-02-06 05:30:00	QQQ	ETF	85.05	85.05	85.0	85.0	460.0
2014-02-06 06:00:00	QQQ	ETF	84.99	85.0	84.97	85.0	12420.0
2014-02-06 06:30:00	QQQ	ETF	84.98	85.02	84.95	85.0	17700.0
2014-02-06 07:00:00	QQQ	ETF	85.0	85.0	84.83	84.83	49628.0
2014-02-06 07:30:00	QQQ	ETF	84.81	84.93	84.71	84.85	88448.0
2014-02-06 08:00:00	QQQ	ETF	85.0	85.1	84.84	85.03	70224.0
2014-02-06 08:30:00	QQQ	ETF	85.09	85.11	84.72	84.9	286039.0
2014-02-06 09:00:00	QQQ	ETF	84.89	85.02	84.79	84.92	106324.0
2014-02-06 09:30:00	QQQ	ETF	84.93	85.49	84.92	85.45	4897106.0
2014-02-06 10:00:00	QQQ	ETF	85.45	85.6715	85.44	85.65	2825644.0
2014-02-06 10:30:00	QQQ	ETF	85.65	85.88	85.65	85.76	2513833.0
2014-02-06 11:00:00	QQQ	ETF	85.75	85.81	85.64	85.6556	1705990.0
2014-02-06 11:30:00	QQQ	ETF	85.66	85.78	85.59	85.591	2055392.0
2014-02-06 12:00:00	QQQ	ETF	85.591	85.74	85.591	85.68	1356085.0
2014-02-06 12:30:00	QQQ	ETF	85.69	85.749	85.64	85.66	1091594.0

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

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