PREVIEW / etf_30min / 2014-12-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-01.parquet
  size:    377 KB
  rows:    12,715

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-12-01 04:00:00	SPY	ETF	206.73	207.0	205.84	206.13	63812.0
2014-12-01 04:30:00	SPY	ETF	206.14	206.33	206.11	206.24	32110.0
2014-12-01 05:00:00	SPY	ETF	206.19	206.29	206.07	206.17	28750.0
2014-12-01 05:30:00	SPY	ETF	206.15	206.3	206.15	206.27	34700.0
2014-12-01 06:00:00	SPY	ETF	206.28	206.3	206.24	206.24	2250.0
2014-12-01 06:30:00	SPY	ETF	206.26	206.45	206.22	206.42	17405.0
2014-12-01 07:00:00	SPY	ETF	206.46	206.63	206.3	206.3	72092.0
2014-12-01 07:30:00	SPY	ETF	206.33	206.4	206.2	206.3	230798.0
2014-12-01 08:00:00	SPY	ETF	206.376	206.5451	206.03	206.16	1105062.0
2014-12-01 08:30:00	SPY	ETF	206.22	207.2	206.21	206.3	377867.0
2014-12-01 09:00:00	SPY	ETF	206.32	207.2	206.31	206.39	684089.0
2014-12-01 09:30:00	SPY	ETF	206.4	206.54	205.46	205.721	13028079.0
2014-12-01 10:00:00	SPY	ETF	205.73	206.43	205.65	206.24	11046431.0
2014-12-01 10:30:00	SPY	ETF	206.25	206.31	205.38	205.48	7768747.0
2014-12-01 11:00:00	SPY	ETF	205.47	205.96	205.44	205.91	11234380.0
2014-12-01 11:30:00	SPY	ETF	205.91	206.0	205.58	205.61	5480188.0
2014-12-01 12:00:00	SPY	ETF	205.61	205.88	205.5699	205.7299	5056261.0
2014-12-01 12:30:00	SPY	ETF	205.729	206.16	205.6105	206.13	4266215.0
2014-12-01 13:00:00	SPY	ETF	206.12	206.35	206.11	206.26	6272033.0
2014-12-01 13:30:00	SPY	ETF	206.255	206.38	206.1	206.16	3135689.0
2014-12-01 14:00:00	SPY	ETF	206.16	206.19	205.61	205.74	4210367.0
2014-12-01 14:30:00	SPY	ETF	205.73	205.98	205.685	205.855	4682973.0
2014-12-01 15:00:00	SPY	ETF	205.8599	206.29	205.81	206.13	6773682.0
2014-12-01 15:30:00	SPY	ETF	206.14	206.17	205.75	205.8	10631925.0
2014-12-01 16:00:00	SPY	ETF	205.79	207.1813	205.5	205.63	3710480.0
2014-12-01 16:30:00	SPY	ETF	205.63	205.64	205.5	205.59	1097560.0
2014-12-01 17:00:00	SPY	ETF	205.59	205.64	205.56	205.62	94880.0
2014-12-01 17:30:00	SPY	ETF	205.59	205.62	205.54	205.58	106526.0
2014-12-01 18:00:00	SPY	ETF	205.6	205.7	205.59	205.66	115189.0
2014-12-01 18:30:00	SPY	ETF	205.63	205.65	205.63	205.64	1220.0
2014-12-01 19:00:00	SPY	ETF	205.65	205.69	205.65	205.67	3201.0
2014-12-01 19:30:00	SPY	ETF	205.67	205.74	205.63	205.64	33674.0
2014-12-01 04:00:00	QQQ	ETF	105.86	105.86	105.43	105.6	1271.0
2014-12-01 04:30:00	QQQ	ETF	105.7	105.8	105.7	105.75	826.0
2014-12-01 05:00:00	QQQ	ETF	105.77	105.77	105.77	105.77	300.0
2014-12-01 05:30:00	QQQ	ETF	105.76	105.77	105.76	105.77	22300.0
2014-12-01 06:00:00	QQQ	ETF	105.77	105.8	105.77	105.77	14325.0
2014-12-01 06:30:00	QQQ	ETF	105.79	105.84	105.75	105.84	10022.0
2014-12-01 07:00:00	QQQ	ETF	105.92	105.92	105.79	105.79	36408.0
2014-12-01 07:30:00	QQQ	ETF	105.78	105.81	105.72	105.73	26044.0
2014-12-01 08:00:00	QQQ	ETF	105.74	105.8	105.51	105.62	54830.0
2014-12-01 08:30:00	QQQ	ETF	105.65	105.72	105.63	105.7	64685.0
2014-12-01 09:00:00	QQQ	ETF	105.7	105.81	105.68	105.72	68214.0
2014-12-01 09:30:00	QQQ	ETF	105.72	105.9199	104.42	105.03	9219601.0
2014-12-01 10:00:00	QQQ	ETF	105.03	105.4	104.96	105.18	3857900.0
2014-12-01 10:30:00	QQQ	ETF	105.19	105.24	104.65	104.72	2412127.0
2014-12-01 11:00:00	QQQ	ETF	104.71	104.95	104.68	104.9	2149370.0
2014-12-01 11:30:00	QQQ	ETF	104.9	104.95	104.72	104.73	1310453.0
2014-12-01 12:00:00	QQQ	ETF	104.72	104.97	104.68	104.89	1201067.0
2014-12-01 12:30:00	QQQ	ETF	104.9	105.05	104.77	105.03	1025248.0

> showing 50 of 12,715 rows — these rows as CSV

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