PREVIEW / etf_30min / 2015-06-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-10.parquet
  size:    382 KB
  rows:    12,854

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-06-10 04:00:00	SPY	ETF	208.98	209.2	208.98	209.2	4410.0
2015-06-10 04:30:00	SPY	ETF	209.09	209.22	208.98	209.22	99656.0
2015-06-10 05:00:00	SPY	ETF	209.12	209.27	209.1	209.27	18695.0
2015-06-10 05:30:00	SPY	ETF	209.29	209.55	209.23	209.5	48444.0
2015-06-10 06:00:00	SPY	ETF	209.45	209.55	209.36	209.4	39365.0
2015-06-10 06:30:00	SPY	ETF	209.41	209.46	209.35	209.4	15435.0
2015-06-10 07:00:00	SPY	ETF	209.38	209.45	209.31	209.33	69159.0
2015-06-10 07:30:00	SPY	ETF	209.31	209.42	209.25	209.39	143335.0
2015-06-10 08:00:00	SPY	ETF	209.38	209.44	209.28	209.3	199526.0
2015-06-10 08:30:00	SPY	ETF	209.3	209.32	209.16	209.25	151711.0
2015-06-10 09:00:00	SPY	ETF	209.25	209.44	209.2	209.38	581186.0
2015-06-10 09:30:00	SPY	ETF	209.37	210.1	209.31	209.9	13849010.0
2015-06-10 10:00:00	SPY	ETF	209.905	210.27	209.905	210.21	9801179.0
2015-06-10 10:30:00	SPY	ETF	210.21	210.6	210.18	210.55	8160305.0
2015-06-10 11:00:00	SPY	ETF	210.56	211.41	210.47	211.02	17418189.0
2015-06-10 11:30:00	SPY	ETF	211.02	211.17	210.93	211.065	8642331.0
2015-06-10 12:00:00	SPY	ETF	211.065	211.25	211.02	211.14	5041733.0
2015-06-10 12:30:00	SPY	ETF	211.135	211.26	211.07	211.19	6244187.0
2015-06-10 13:00:00	SPY	ETF	211.19	211.25	210.96	211.035	4154844.0
2015-06-10 13:30:00	SPY	ETF	211.03	211.09	210.92	211.08	3042071.0
2015-06-10 14:00:00	SPY	ETF	211.075	211.39	211.07	211.31	12159493.0
2015-06-10 14:30:00	SPY	ETF	211.31	211.35	211.19	211.3499	4601388.0
2015-06-10 15:00:00	SPY	ETF	211.35	211.35	211.1001	211.19	5397888.0
2015-06-10 15:30:00	SPY	ETF	211.18	211.28	210.94	210.95	23358050.0
2015-06-10 16:00:00	SPY	ETF	210.95	211.37	210.94	211.24	6352720.0
2015-06-10 16:30:00	SPY	ETF	211.24	211.28	211.14	211.28	2475759.0
2015-06-10 17:00:00	SPY	ETF	211.27	211.3	211.22	211.22	53002.0
2015-06-10 17:30:00	SPY	ETF	211.25	211.28	210.95	211.24	135185.0
2015-06-10 18:00:00	SPY	ETF	211.19	211.19	211.02	211.059	172275.0
2015-06-10 18:30:00	SPY	ETF	211.059	211.06	210.99	211.01	53190.0
2015-06-10 19:00:00	SPY	ETF	211.04	211.06	211.0	211.05	15818.0
2015-06-10 19:30:00	SPY	ETF	211.06	211.11	211.03	211.06	502835.0
2015-06-10 04:00:00	QQQ	ETF	108.41	108.41	108.41	108.41	20000.0
2015-06-10 05:00:00	QQQ	ETF	108.44	108.44	108.44	108.44	1500.0
2015-06-10 05:30:00	QQQ	ETF	108.47	108.55	108.47	108.55	500.0
2015-06-10 06:00:00	QQQ	ETF	108.69	108.69	108.59	108.63	10500.0
2015-06-10 06:30:00	QQQ	ETF	108.62	108.62	108.57	108.57	4700.0
2015-06-10 07:00:00	QQQ	ETF	108.6	108.61	108.55	108.55	32350.0
2015-06-10 07:30:00	QQQ	ETF	108.52	108.6	108.51	108.6	20162.0
2015-06-10 08:00:00	QQQ	ETF	108.57	108.59	108.46	108.49	8982.0
2015-06-10 08:30:00	QQQ	ETF	108.47	108.48	108.38	108.41	82144.0
2015-06-10 09:00:00	QQQ	ETF	108.41	108.49	108.37	108.37	82389.0
2015-06-10 09:30:00	QQQ	ETF	108.38	108.76	108.26	108.65	3077664.0
2015-06-10 10:00:00	QQQ	ETF	108.66	109.04	108.65	108.99	2229986.0
2015-06-10 10:30:00	QQQ	ETF	108.99	109.25	108.97	109.24	2181634.0
2015-06-10 11:00:00	QQQ	ETF	109.24	109.69	109.16	109.506	3192437.0
2015-06-10 11:30:00	QQQ	ETF	109.5	109.64	109.46	109.55	1405412.0
2015-06-10 12:00:00	QQQ	ETF	109.54	109.64	109.49	109.55	942598.0
2015-06-10 12:30:00	QQQ	ETF	109.56	109.66	109.54	109.64	992747.0
2015-06-10 13:00:00	QQQ	ETF	109.645	109.69	109.5	109.55	737707.0

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

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