PREVIEW / etf_30min / 2015-05-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-14.parquet
  size:    376 KB
  rows:    12,728

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
2015-05-14 04:00:00	SPY	ETF	210.65	210.75	210.65	210.69	45575.0
2015-05-14 04:30:00	SPY	ETF	210.7	211.12	210.7	210.97	51520.0
2015-05-14 05:00:00	SPY	ETF	211.0	211.0	210.9	210.97	37600.0
2015-05-14 05:30:00	SPY	ETF	210.92	210.98	210.86	210.86	6312.0
2015-05-14 06:00:00	SPY	ETF	210.87	210.93	210.82	210.82	7154.0
2015-05-14 06:30:00	SPY	ETF	210.83	211.01	210.83	211.0	20650.0
2015-05-14 07:00:00	SPY	ETF	210.97	211.01	210.84	210.86	123849.0
2015-05-14 07:30:00	SPY	ETF	210.82	211.33	210.82	211.27	300411.0
2015-05-14 08:00:00	SPY	ETF	211.25	211.33	210.91	211.22	390406.0
2015-05-14 08:30:00	SPY	ETF	211.25	211.28	211.1	211.22	382235.0
2015-05-14 09:00:00	SPY	ETF	211.25	211.36	211.19	211.26	664918.0
2015-05-14 09:30:00	SPY	ETF	211.24	211.48	210.91	211.08	11111115.0
2015-05-14 10:00:00	SPY	ETF	211.08	211.65	210.94	211.51	7571430.0
2015-05-14 10:30:00	SPY	ETF	211.5	211.59	211.39	211.51	3205998.0
2015-05-14 11:00:00	SPY	ETF	211.51	211.62	211.33	211.48	4121709.0
2015-05-14 11:30:00	SPY	ETF	211.49	211.62	211.37	211.565	4119374.0
2015-05-14 12:00:00	SPY	ETF	211.57	211.83	211.46	211.7884	3853695.0
2015-05-14 12:30:00	SPY	ETF	211.78	211.925	211.67	211.9	4363159.0
2015-05-14 13:00:00	SPY	ETF	211.905	212.11	211.86	212.11	4475679.0
2015-05-14 13:30:00	SPY	ETF	212.1	212.19	212.04	212.06	4371783.0
2015-05-14 14:00:00	SPY	ETF	212.05	212.2	212.0	212.14	7847944.0
2015-05-14 14:30:00	SPY	ETF	212.15	212.19	212.01	212.15	3324334.0
2015-05-14 15:00:00	SPY	ETF	212.14	212.29	212.1	212.18	8923739.0
2015-05-14 15:30:00	SPY	ETF	212.195	212.32	212.06	212.21	14852106.0
2015-05-14 16:00:00	SPY	ETF	212.22	212.4	212.19	212.28	7255001.0
2015-05-14 16:30:00	SPY	ETF	212.27	212.34	212.22	212.3	2836729.0
2015-05-14 17:00:00	SPY	ETF	212.32	212.32	212.27	212.27	8771.0
2015-05-14 17:30:00	SPY	ETF	212.3	212.33	212.27	212.33	8585.0
2015-05-14 18:00:00	SPY	ETF	212.27	212.28	212.22	212.25	43241.0
2015-05-14 18:30:00	SPY	ETF	212.23	212.28	212.22	212.28	6300.0
2015-05-14 19:00:00	SPY	ETF	212.25	212.27	212.21	212.23	5840.0
2015-05-14 19:30:00	SPY	ETF	212.24	212.27	212.24	212.27	45803.0
2015-05-14 04:00:00	QQQ	ETF	108.42	108.42	108.42	108.42	165.0
2015-05-14 04:30:00	QQQ	ETF	108.47	108.6	108.43	108.6	79530.0
2015-05-14 05:00:00	QQQ	ETF	108.45	108.45	108.45	108.45	200.0
2015-05-14 06:00:00	QQQ	ETF	108.53	108.54	108.48	108.49	2300.0
2015-05-14 06:30:00	QQQ	ETF	108.49	108.65	108.49	108.57	32550.0
2015-05-14 07:00:00	QQQ	ETF	108.59	108.59	108.5	108.5	45398.0
2015-05-14 07:30:00	QQQ	ETF	108.52	108.77	108.52	108.75	49198.0
2015-05-14 08:00:00	QQQ	ETF	108.74	108.78	108.7	108.75	72218.0
2015-05-14 08:30:00	QQQ	ETF	108.75	108.8	108.67	108.8	73125.0
2015-05-14 09:00:00	QQQ	ETF	108.8	108.91	108.79	108.87	136781.0
2015-05-14 09:30:00	QQQ	ETF	108.88	108.96	108.48	108.6544	3447488.0
2015-05-14 10:00:00	QQQ	ETF	108.65	109.08	108.57	108.995	2198429.0
2015-05-14 10:30:00	QQQ	ETF	109.0	109.09	108.935	109.055	1079548.0
2015-05-14 11:00:00	QQQ	ETF	109.055	109.2	109.015	109.105	1267038.0
2015-05-14 11:30:00	QQQ	ETF	109.11	109.23	109.04	109.2	991562.0
2015-05-14 12:00:00	QQQ	ETF	109.2	109.32	109.12	109.28	1120818.0
2015-05-14 12:30:00	QQQ	ETF	109.285	109.37	109.23	109.36	1057263.0
2015-05-14 13:00:00	QQQ	ETF	109.36	109.48	109.35	109.479	668702.0

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

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