PREVIEW / etf_30min / 2014-01-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-29.parquet
  size:    356 KB
  rows:    11,871

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-01-29 04:00:00	SPY	ETF	180.05	180.05	179.43	179.6	145149.0
2014-01-29 04:30:00	SPY	ETF	179.67	179.78	179.55	179.72	9441.0
2014-01-29 05:00:00	SPY	ETF	179.7	179.7	179.55	179.63	18065.0
2014-01-29 05:30:00	SPY	ETF	179.64	179.65	179.26	179.4	43294.0
2014-01-29 06:00:00	SPY	ETF	179.35	179.35	179.19	179.33	34837.0
2014-01-29 06:30:00	SPY	ETF	179.34	179.35	178.82	179.11	565108.0
2014-01-29 07:00:00	SPY	ETF	179.19	179.47	178.78	178.9	662515.0
2014-01-29 07:30:00	SPY	ETF	178.87	179.03	178.36	178.69	1693732.0
2014-01-29 08:00:00	SPY	ETF	178.7	179.39	178.26	178.34	2344981.0
2014-01-29 08:30:00	SPY	ETF	178.32	178.46	177.67	177.96	4659996.0
2014-01-29 09:00:00	SPY	ETF	177.98	178.01	177.32	177.56	5394749.0
2014-01-29 09:30:00	SPY	ETF	177.56	178.21	177.27	177.9691	25219339.0
2014-01-29 10:00:00	SPY	ETF	177.96	178.38	177.57	177.81	17477556.0
2014-01-29 10:30:00	SPY	ETF	177.81	178.29	177.74	178.085	10446381.0
2014-01-29 11:00:00	SPY	ETF	178.09	178.54	178.09	178.5	9328282.0
2014-01-29 11:30:00	SPY	ETF	178.5	178.55	178.18	178.49	6507024.0
2014-01-29 12:00:00	SPY	ETF	178.49	178.54	178.011	178.0228	7515812.0
2014-01-29 12:30:00	SPY	ETF	178.02	178.1	177.79	178.04	5812415.0
2014-01-29 13:00:00	SPY	ETF	178.04	178.07	177.79	177.9	4996723.0
2014-01-29 13:30:00	SPY	ETF	177.9	178.06	177.67	178.01	7577357.0
2014-01-29 14:00:00	SPY	ETF	178.01	178.43	176.88	177.7501	31507077.0
2014-01-29 14:30:00	SPY	ETF	177.76	178.24	177.22	177.27	14080194.0
2014-01-29 15:00:00	SPY	ETF	177.27	177.45	176.93	177.18	16342736.0
2014-01-29 15:30:00	SPY	ETF	177.18	177.71	176.96	177.32	24843658.0
2014-01-29 16:00:00	SPY	ETF	177.3	179.1369	177.27	177.55	9167428.0
2014-01-29 16:30:00	SPY	ETF	177.55	179.1369	177.35	177.44	4867448.0
2014-01-29 17:00:00	SPY	ETF	177.43	177.63	177.4	177.6	317825.0
2014-01-29 17:30:00	SPY	ETF	177.6	177.6	177.5	177.53	2142450.0
2014-01-29 18:00:00	SPY	ETF	177.51	177.92	177.49	177.81	631298.0
2014-01-29 18:30:00	SPY	ETF	177.81	178.05	177.81	177.99	95241.0
2014-01-29 19:00:00	SPY	ETF	177.95	177.96	177.85	177.88	438488.0
2014-01-29 19:30:00	SPY	ETF	177.88	177.93	177.69	177.89	187718.0
2014-01-29 04:00:00	QQQ	ETF	86.39	86.39	86.15	86.18	4100.0
2014-01-29 06:00:00	QQQ	ETF	86.01	86.04	85.99	86.04	6000.0
2014-01-29 06:30:00	QQQ	ETF	86.04	86.06	85.82	85.98	14920.0
2014-01-29 07:00:00	QQQ	ETF	86.0	86.1	85.7	85.73	75159.0
2014-01-29 07:30:00	QQQ	ETF	85.75	85.82	85.45	85.62	81030.0
2014-01-29 08:00:00	QQQ	ETF	85.61	86.07	85.41	85.43	76560.0
2014-01-29 08:30:00	QQQ	ETF	85.42	85.51	85.07	85.24	530295.0
2014-01-29 09:00:00	QQQ	ETF	85.24	85.41	84.9	85.1	682215.0
2014-01-29 09:30:00	QQQ	ETF	85.1	85.48	84.87	85.36	7043138.0
2014-01-29 10:00:00	QQQ	ETF	85.3599	85.5	85.06	85.16	2969093.0
2014-01-29 10:30:00	QQQ	ETF	85.18	85.42	85.11	85.3	2132266.0
2014-01-29 11:00:00	QQQ	ETF	85.3	85.56	85.3	85.53	1537082.0
2014-01-29 11:30:00	QQQ	ETF	85.54	85.68	85.49	85.68	2576278.0
2014-01-29 12:00:00	QQQ	ETF	85.675	85.74	85.4	85.408	1788001.0
2014-01-29 12:30:00	QQQ	ETF	85.4	85.42	85.241	85.371	1251908.0
2014-01-29 13:00:00	QQQ	ETF	85.355	85.4	85.27	85.33	716088.0
2014-01-29 13:30:00	QQQ	ETF	85.34	85.38	85.22	85.34	2056312.0
2014-01-29 14:00:00	QQQ	ETF	85.31	85.53	84.78	85.17	7882794.0

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

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