PREVIEW / etf_30min / 2014-06-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-18.parquet
  size:    337 KB
  rows:    11,374

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-06-18 04:30:00	SPY	ETF	194.83	194.83	194.83	194.83	500.0
2014-06-18 05:30:00	SPY	ETF	194.74	194.74	194.74	194.74	850.0
2014-06-18 06:00:00	SPY	ETF	194.78	194.78	194.76	194.76	1016.0
2014-06-18 06:30:00	SPY	ETF	194.76	194.83	194.76	194.83	29119.0
2014-06-18 07:00:00	SPY	ETF	194.79	194.84	194.77	194.83	314150.0
2014-06-18 07:30:00	SPY	ETF	194.85	194.85	194.72	194.74	164469.0
2014-06-18 08:00:00	SPY	ETF	194.75	194.81	194.74	194.75	65931.0
2014-06-18 08:30:00	SPY	ETF	194.75	194.84	194.72	194.82	156668.0
2014-06-18 09:00:00	SPY	ETF	194.82	194.87	194.74	194.84	431060.0
2014-06-18 09:30:00	SPY	ETF	194.83	195.08	194.68	195.02	7703280.0
2014-06-18 10:00:00	SPY	ETF	195.02	195.07	194.75	194.92	5837689.0
2014-06-18 10:30:00	SPY	ETF	194.91	194.95	194.5	194.51	4649522.0
2014-06-18 11:00:00	SPY	ETF	194.5	194.74	194.45	194.65	3915925.0
2014-06-18 11:30:00	SPY	ETF	194.66	194.76	194.65	194.675	1942440.0
2014-06-18 12:00:00	SPY	ETF	194.67	194.72	194.6	194.675	2397693.0
2014-06-18 12:30:00	SPY	ETF	194.68	194.9	194.65	194.86	5443574.0
2014-06-18 13:00:00	SPY	ETF	194.865	194.9	194.76	194.77	4268856.0
2014-06-18 13:30:00	SPY	ETF	194.775	194.81	194.53	194.71	5208688.0
2014-06-18 14:00:00	SPY	ETF	194.7	195.44	194.4	195.39	15121871.0
2014-06-18 14:30:00	SPY	ETF	195.39	195.69	195.25	195.6	10607854.0
2014-06-18 15:00:00	SPY	ETF	195.61	195.97	195.59	195.95	8391873.0
2014-06-18 15:30:00	SPY	ETF	195.94	196.37	195.9	196.25	17951841.0
2014-06-18 16:00:00	SPY	ETF	196.24	196.35	194.8456	196.27	6537814.0
2014-06-18 16:30:00	SPY	ETF	196.27	196.27	196.2	196.24	2039743.0
2014-06-18 17:00:00	SPY	ETF	196.25	196.26	196.18	196.22	114503.0
2014-06-18 17:30:00	SPY	ETF	196.21	196.24	196.21	196.21	14694.0
2014-06-18 18:00:00	SPY	ETF	196.21	196.25	196.18	196.19	19050.0
2014-06-18 18:30:00	SPY	ETF	196.23	196.28	196.22	196.28	22468.0
2014-06-18 19:00:00	SPY	ETF	196.27	196.28	196.26	196.27	4720.0
2014-06-18 19:30:00	SPY	ETF	196.27	196.28	196.21	196.24	72335.0
2014-06-18 04:30:00	QQQ	ETF	92.64	92.64	92.64	92.64	1500.0
2014-06-18 07:30:00	QQQ	ETF	92.57	92.57	92.57	92.57	100.0
2014-06-18 08:00:00	QQQ	ETF	92.61	92.61	92.51	92.53	3048.0
2014-06-18 08:30:00	QQQ	ETF	92.52	92.55	92.52	92.53	3920.0
2014-06-18 09:00:00	QQQ	ETF	92.56	92.6	92.53	92.55	149199.0
2014-06-18 09:30:00	QQQ	ETF	92.55	92.6	92.39	92.43	3034260.0
2014-06-18 10:00:00	QQQ	ETF	92.4397	92.49	92.24	92.4792	1464016.0
2014-06-18 10:30:00	QQQ	ETF	92.48	92.5	92.265	92.27	1210212.0
2014-06-18 11:00:00	QQQ	ETF	92.27	92.385	92.24	92.31	781745.0
2014-06-18 11:30:00	QQQ	ETF	92.31	92.38	92.31	92.34	472681.0
2014-06-18 12:00:00	QQQ	ETF	92.35	92.35	92.28	92.3	489373.0
2014-06-18 12:30:00	QQQ	ETF	92.3	92.4	92.295	92.37	639193.0
2014-06-18 13:00:00	QQQ	ETF	92.37	92.38	92.25	92.255	391856.0
2014-06-18 13:30:00	QQQ	ETF	92.25	92.255	92.07	92.158	1447374.0
2014-06-18 14:00:00	QQQ	ETF	92.14	92.61	91.98	92.565	5742989.0
2014-06-18 14:30:00	QQQ	ETF	92.565	92.73	92.5	92.6999	2984164.0
2014-06-18 15:00:00	QQQ	ETF	92.7	92.889	92.69	92.864	3300337.0
2014-06-18 15:30:00	QQQ	ETF	92.8652	93.1	92.85	92.99	5181071.0
2014-06-18 16:00:00	QQQ	ETF	92.99	93.06	92.4169	93.01	1292057.0
2014-06-18 16:30:00	QQQ	ETF	93.01	93.01	92.98	92.98	50860.0

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

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