PREVIEW / etf_30min / 2014-07-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-29.parquet
  size:    340 KB
  rows:    11,798

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-07-29 04:00:00	SPY	ETF	197.58	197.58	197.33	197.33	6144.0
2014-07-29 04:30:00	SPY	ETF	197.37	197.49	197.35	197.49	850.0
2014-07-29 05:00:00	SPY	ETF	197.5	197.51	197.5	197.51	2000.0
2014-07-29 05:30:00	SPY	ETF	197.5	197.65	197.44	197.56	2100.0
2014-07-29 06:00:00	SPY	ETF	197.6	197.64	197.6	197.64	1416.0
2014-07-29 06:30:00	SPY	ETF	197.76	197.95	197.76	197.95	34350.0
2014-07-29 07:00:00	SPY	ETF	197.96	198.16	197.96	198.1	235708.0
2014-07-29 07:30:00	SPY	ETF	198.16	198.16	198.02	198.04	56075.0
2014-07-29 08:00:00	SPY	ETF	198.11	198.25	197.59	198.17	303690.0
2014-07-29 08:30:00	SPY	ETF	198.17	198.2	197.97	198.06	253706.0
2014-07-29 09:00:00	SPY	ETF	198.05	198.19	198.03	198.17	610171.0
2014-07-29 09:30:00	SPY	ETF	198.17	198.345	197.83	198.19	7488096.0
2014-07-29 10:00:00	SPY	ETF	198.19	198.45	198.14	198.33	7037982.0
2014-07-29 10:30:00	SPY	ETF	198.33	198.38	198.04	198.07	3887481.0
2014-07-29 11:00:00	SPY	ETF	198.07	198.11	197.39	197.58	7605580.0
2014-07-29 11:30:00	SPY	ETF	197.57	197.65	197.24	197.64	5561655.0
2014-07-29 12:00:00	SPY	ETF	197.64	197.95	197.58	197.9	4420482.0
2014-07-29 12:30:00	SPY	ETF	197.9	198.05	197.85	198.02	3601259.0
2014-07-29 13:00:00	SPY	ETF	198.025	198.09	197.84	197.98	3855641.0
2014-07-29 13:30:00	SPY	ETF	197.98	197.98	197.84	197.9299	1882806.0
2014-07-29 14:00:00	SPY	ETF	197.93	198.01	197.35	197.58	4171185.0
2014-07-29 14:30:00	SPY	ETF	197.57	197.8	197.41	197.485	3624926.0
2014-07-29 15:00:00	SPY	ETF	197.48	197.55	197.27	197.33	4933294.0
2014-07-29 15:30:00	SPY	ETF	197.33	197.34	196.94	196.95	13828176.0
2014-07-29 16:00:00	SPY	ETF	196.94	197.8098	196.7	196.87	5900511.0
2014-07-29 16:30:00	SPY	ETF	196.86	196.96	196.84	196.95	264548.0
2014-07-29 17:00:00	SPY	ETF	196.95	196.97	196.89	196.97	52666.0
2014-07-29 17:30:00	SPY	ETF	196.96	196.96	196.85	196.92	44574.0
2014-07-29 18:00:00	SPY	ETF	196.91	197.03	196.91	197.0	34310.0
2014-07-29 18:30:00	SPY	ETF	196.96	196.97	196.89	196.92	6250.0
2014-07-29 19:00:00	SPY	ETF	196.94	196.96	196.92	196.95	3896.0
2014-07-29 19:30:00	SPY	ETF	196.92	196.97	196.92	196.97	16972.0
2014-07-29 04:00:00	QQQ	ETF	96.64	96.64	96.64	96.64	2500.0
2014-07-29 04:30:00	QQQ	ETF	96.67	96.68	96.67	96.68	2000.0
2014-07-29 05:30:00	QQQ	ETF	96.75	96.78	96.75	96.78	1100.0
2014-07-29 06:00:00	QQQ	ETF	96.75	96.75	96.75	96.75	2500.0
2014-07-29 06:30:00	QQQ	ETF	96.85	96.85	96.85	96.85	100.0
2014-07-29 07:00:00	QQQ	ETF	96.85	97.07	96.84	96.99	26100.0
2014-07-29 07:30:00	QQQ	ETF	96.92	96.95	96.9	96.93	6850.0
2014-07-29 08:00:00	QQQ	ETF	96.91	97.03	96.91	96.97	106872.0
2014-07-29 08:30:00	QQQ	ETF	96.98	96.98	96.88	96.92	49471.0
2014-07-29 09:00:00	QQQ	ETF	96.93	96.98	96.91	96.98	101490.0
2014-07-29 09:30:00	QQQ	ETF	96.97	97.13	96.82	97.02	3159497.0
2014-07-29 10:00:00	QQQ	ETF	97.03	97.175	96.99	97.16	2283714.0
2014-07-29 10:30:00	QQQ	ETF	97.16	97.2	96.96	97.0	1493084.0
2014-07-29 11:00:00	QQQ	ETF	97.0	97.048	96.59	96.73	2648571.0
2014-07-29 11:30:00	QQQ	ETF	96.73	96.82	96.52	96.818	1569489.0
2014-07-29 12:00:00	QQQ	ETF	96.819	96.94	96.79	96.91	1266745.0
2014-07-29 12:30:00	QQQ	ETF	96.91	96.98	96.88	96.9201	936117.0
2014-07-29 13:00:00	QQQ	ETF	96.92	97.03	96.87	96.98	1090905.0

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

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