PREVIEW / etf_30min / 2015-05-04

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-04.parquet
  size:    377 KB
  rows:    12,795

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-04 04:00:00	SPY	ETF	210.75	210.92	210.75	210.92	335.0
2015-05-04 04:30:00	SPY	ETF	210.99	211.15	210.99	211.12	6675.0
2015-05-04 05:00:00	SPY	ETF	211.14	211.2	211.14	211.2	1600.0
2015-05-04 05:30:00	SPY	ETF	211.1	211.11	211.0	211.08	18360.0
2015-05-04 06:00:00	SPY	ETF	211.08	211.08	210.98	210.98	6900.0
2015-05-04 06:30:00	SPY	ETF	211.05	211.25	211.04	211.19	44120.0
2015-05-04 07:00:00	SPY	ETF	211.19	211.31	211.18	211.18	93670.0
2015-05-04 07:30:00	SPY	ETF	211.18	211.38	211.18	211.3	56821.0
2015-05-04 08:00:00	SPY	ETF	211.3	211.38	211.18	211.28	173848.0
2015-05-04 08:30:00	SPY	ETF	211.28	211.35	211.25	211.32	112525.0
2015-05-04 09:00:00	SPY	ETF	211.32	211.32	211.15	211.25	388098.0
2015-05-04 09:30:00	SPY	ETF	211.23	211.98	211.1	211.91	9890197.0
2015-05-04 10:00:00	SPY	ETF	211.919	212.02	211.74	211.9	5560337.0
2015-05-04 10:30:00	SPY	ETF	211.9	211.95	211.53	211.6	5081019.0
2015-05-04 11:00:00	SPY	ETF	211.61	211.75	211.54	211.63	3806254.0
2015-05-04 11:30:00	SPY	ETF	211.63	211.67	211.41	211.655	2799382.0
2015-05-04 12:00:00	SPY	ETF	211.65	211.74	211.48	211.64	2566824.0
2015-05-04 12:30:00	SPY	ETF	211.65	211.71	211.37	211.43	2588163.0
2015-05-04 13:00:00	SPY	ETF	211.43	211.47	211.18	211.34	3561158.0
2015-05-04 13:30:00	SPY	ETF	211.34	211.56	211.26	211.535	2623383.0
2015-05-04 14:00:00	SPY	ETF	211.54	211.69	211.4	211.65	3840123.0
2015-05-04 14:30:00	SPY	ETF	211.66	211.75	211.51	211.545	2998665.0
2015-05-04 15:00:00	SPY	ETF	211.55	211.7	211.43	211.615	6090199.0
2015-05-04 15:30:00	SPY	ETF	211.615	211.7	211.31	211.34	9501567.0
2015-05-04 16:00:00	SPY	ETF	211.34	211.6268	211.27	211.47	4363409.0
2015-05-04 16:30:00	SPY	ETF	211.46	211.52	211.39	211.44	1815120.0
2015-05-04 17:00:00	SPY	ETF	211.44	211.47	211.43	211.45	17756.0
2015-05-04 17:30:00	SPY	ETF	211.45	211.45	211.41	211.44	45044.0
2015-05-04 18:00:00	SPY	ETF	211.44	211.49	211.36	211.49	61261.0
2015-05-04 18:30:00	SPY	ETF	211.49	211.49	211.42	211.42	15026.0
2015-05-04 19:00:00	SPY	ETF	211.42	211.44	211.41	211.41	7491.0
2015-05-04 19:30:00	SPY	ETF	211.41	211.44	211.39	211.44	12162.0
2015-05-04 04:30:00	QQQ	ETF	109.18	109.18	109.18	109.18	3700.0
2015-05-04 05:00:00	QQQ	ETF	109.18	109.18	109.18	109.18	2550.0
2015-05-04 05:30:00	QQQ	ETF	109.19	109.21	109.13	109.13	16000.0
2015-05-04 06:00:00	QQQ	ETF	109.15	109.15	109.14	109.14	400.0
2015-05-04 06:30:00	QQQ	ETF	109.18	109.23	109.16	109.18	37750.0
2015-05-04 07:00:00	QQQ	ETF	109.18	109.24	109.18	109.22	48500.0
2015-05-04 07:30:00	QQQ	ETF	109.21	109.36	109.21	109.32	13245.0
2015-05-04 08:00:00	QQQ	ETF	109.32	109.4	109.32	109.34	26953.0
2015-05-04 08:30:00	QQQ	ETF	109.34	109.38	109.3	109.34	36839.0
2015-05-04 09:00:00	QQQ	ETF	109.35	109.4	109.3	109.39	81629.0
2015-05-04 09:30:00	QQQ	ETF	109.4	109.9	109.3	109.88	4044556.0
2015-05-04 10:00:00	QQQ	ETF	109.88	109.91	109.66	109.8	2099180.0
2015-05-04 10:30:00	QQQ	ETF	109.8	109.85	109.49	109.51	1799607.0
2015-05-04 11:00:00	QQQ	ETF	109.54	109.62	109.46	109.56	1026844.0
2015-05-04 11:30:00	QQQ	ETF	109.555	109.59	109.43	109.57	819228.0
2015-05-04 12:00:00	QQQ	ETF	109.58	109.67	109.5	109.625	809123.0
2015-05-04 12:30:00	QQQ	ETF	109.625	109.64	109.35	109.4	796644.0
2015-05-04 13:00:00	QQQ	ETF	109.4	109.42	109.17	109.2897	1463117.0

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

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