PREVIEW / etf_30min / 2013-06-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-12.parquet
  size:    330 KB
  rows:    10,825

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
2013-06-12 04:00:00	SPY	ETF	163.92	164.05	163.7	163.82	66350.0
2013-06-12 04:30:00	SPY	ETF	163.85	163.95	163.75	163.9	3250.0
2013-06-12 05:00:00	SPY	ETF	163.88	164.11	163.88	164.03	49800.0
2013-06-12 05:30:00	SPY	ETF	164.0	164.05	163.88	163.9	78800.0
2013-06-12 06:00:00	SPY	ETF	163.94	164.18	163.94	164.16	17521.0
2013-06-12 06:30:00	SPY	ETF	164.18	164.27	164.06	164.2	63380.0
2013-06-12 07:00:00	SPY	ETF	164.2	164.22	164.0	164.09	182932.0
2013-06-12 07:30:00	SPY	ETF	164.08	164.22	164.05	164.18	225364.0
2013-06-12 08:00:00	SPY	ETF	164.18	164.21	163.98	164.04	314273.0
2013-06-12 08:30:00	SPY	ETF	164.04	164.16	163.92	164.14	459622.0
2013-06-12 09:00:00	SPY	ETF	164.12	164.34	164.11	164.22	786624.0
2013-06-12 09:30:00	SPY	ETF	164.22	164.39	163.73	163.82	13836044.0
2013-06-12 10:00:00	SPY	ETF	163.83	163.83	163.2	163.625	13015937.0
2013-06-12 10:30:00	SPY	ETF	163.6	163.73	162.96	163.05	11919310.0
2013-06-12 11:00:00	SPY	ETF	163.04	163.25	162.83	163.11	9705555.0
2013-06-12 11:30:00	SPY	ETF	163.11	163.25	162.21	162.379	13690460.0
2013-06-12 12:00:00	SPY	ETF	162.38	162.53	162.041	162.29	10407782.0
2013-06-12 12:30:00	SPY	ETF	162.3	162.54	161.98	162.49	9493782.0
2013-06-12 13:00:00	SPY	ETF	162.5	162.8	162.38	162.57	7564395.0
2013-06-12 13:30:00	SPY	ETF	162.58	162.72	162.23	162.599	5121429.0
2013-06-12 14:00:00	SPY	ETF	162.598	162.62	161.93	162.1	9298493.0
2013-06-12 14:30:00	SPY	ETF	162.09	162.45	161.8	162.03	11907890.0
2013-06-12 15:00:00	SPY	ETF	162.02	162.035	161.6	161.94	13356062.0
2013-06-12 15:30:00	SPY	ETF	161.945	162.1	161.68	161.77	23448925.0
2013-06-12 16:00:00	SPY	ETF	161.77	162.5691	161.54	161.64	12031252.0
2013-06-12 16:30:00	SPY	ETF	161.65	163.1717	161.63	161.68	4488109.0
2013-06-12 17:00:00	SPY	ETF	161.68	161.69	161.59	161.64	209829.0
2013-06-12 17:30:00	SPY	ETF	161.63	161.68	161.63	161.66	74551.0
2013-06-12 18:00:00	SPY	ETF	161.66	161.76	161.62	161.62	233508.0
2013-06-12 18:30:00	SPY	ETF	161.66	161.66	161.59	161.6	31664.0
2013-06-12 19:00:00	SPY	ETF	161.58	161.62	161.56	161.6	17919.0
2013-06-12 19:30:00	SPY	ETF	161.6	161.69	161.6	161.63	119703.0
2013-06-12 04:00:00	QQQ	ETF	73.02	73.05	72.88	72.96	8100.0
2013-06-12 04:30:00	QQQ	ETF	72.98	73.04	72.98	73.04	3200.0
2013-06-12 05:00:00	QQQ	ETF	73.06	73.14	73.06	73.1	5500.0
2013-06-12 05:30:00	QQQ	ETF	73.08	73.08	72.98	72.98	4200.0
2013-06-12 06:00:00	QQQ	ETF	72.99	73.1	72.99	73.1	4900.0
2013-06-12 06:30:00	QQQ	ETF	73.08	73.12	73.06	73.1	3891.0
2013-06-12 07:00:00	QQQ	ETF	73.11	73.12	73.04	73.08	6700.0
2013-06-12 07:30:00	QQQ	ETF	73.08	73.12	73.08	73.1	8550.0
2013-06-12 08:00:00	QQQ	ETF	73.08	73.12	73.04	73.05	14048.0
2013-06-12 08:30:00	QQQ	ETF	73.04	73.1	72.99	73.07	40178.0
2013-06-12 09:00:00	QQQ	ETF	73.08	73.16	73.06	73.1	115968.0
2013-06-12 09:30:00	QQQ	ETF	73.11	73.14	72.78	72.8	4132745.0
2013-06-12 10:00:00	QQQ	ETF	72.81	72.82	72.51	72.73	3514203.0
2013-06-12 10:30:00	QQQ	ETF	72.73	72.8	72.48	72.5	3877113.0
2013-06-12 11:00:00	QQQ	ETF	72.51	72.62	72.42	72.53	2729778.0
2013-06-12 11:30:00	QQQ	ETF	72.53	72.61	72.14	72.201	3990407.0
2013-06-12 12:00:00	QQQ	ETF	72.21	72.259	72.02	72.11	2076724.0
2013-06-12 12:30:00	QQQ	ETF	72.11	72.2655	71.99	72.25	3494611.0

> showing 50 of 10,825 rows — these rows as CSV

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