PREVIEW / etf_30min / 2015-07-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-20.parquet
  size:    382 KB
  rows:    13,029

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-07-20 04:00:00	SPY	ETF	212.64	212.7	212.62	212.62	6000.0
2015-07-20 04:30:00	SPY	ETF	212.66	212.81	212.59	212.75	64171.0
2015-07-20 05:00:00	SPY	ETF	212.74	212.77	212.64	212.64	4401.0
2015-07-20 05:30:00	SPY	ETF	212.66	212.74	212.64	212.71	2008.0
2015-07-20 06:00:00	SPY	ETF	212.71	212.8	212.66	212.69	39100.0
2015-07-20 06:30:00	SPY	ETF	212.7	212.7	212.66	212.68	1529.0
2015-07-20 07:00:00	SPY	ETF	212.65	212.65	212.62	212.64	17318.0
2015-07-20 07:30:00	SPY	ETF	212.63	212.75	212.63	212.72	73729.0
2015-07-20 08:00:00	SPY	ETF	212.66	212.75	212.65	212.75	129440.0
2015-07-20 08:30:00	SPY	ETF	212.74	212.75	212.58	212.6	204598.0
2015-07-20 09:00:00	SPY	ETF	212.6	212.8	212.58	212.75	3311684.0
2015-07-20 09:30:00	SPY	ETF	212.75	212.77	212.27	212.38	8437295.0
2015-07-20 10:00:00	SPY	ETF	212.38	212.49	212.21	212.4	5535425.0
2015-07-20 10:30:00	SPY	ETF	212.39	212.69	212.34	212.64	3089894.0
2015-07-20 11:00:00	SPY	ETF	212.64	212.895	212.6201	212.75	4807477.0
2015-07-20 11:30:00	SPY	ETF	212.75	212.82	212.64	212.81	2185479.0
2015-07-20 12:00:00	SPY	ETF	212.8	212.91	212.76	212.773	2141491.0
2015-07-20 12:30:00	SPY	ETF	212.77	212.99	212.77	212.92	2293450.0
2015-07-20 13:00:00	SPY	ETF	212.92	213.01	212.89	213.0	1975014.0
2015-07-20 13:30:00	SPY	ETF	213.0	213.05	212.7801	212.82	3944991.0
2015-07-20 14:00:00	SPY	ETF	212.82	213.1	212.81	213.055	5666649.0
2015-07-20 14:30:00	SPY	ETF	213.06	213.12	212.95	212.97	3315470.0
2015-07-20 15:00:00	SPY	ETF	212.97	213.18	212.86	212.88	6017571.0
2015-07-20 15:30:00	SPY	ETF	212.885	212.93	212.52	212.61	9983195.0
2015-07-20 16:00:00	SPY	ETF	212.61	212.82	212.2722	212.71	2023945.0
2015-07-20 16:30:00	SPY	ETF	212.71	212.74	212.59	212.73	4505083.0
2015-07-20 17:00:00	SPY	ETF	212.73	212.82	212.73	212.77	93408.0
2015-07-20 17:30:00	SPY	ETF	212.77	212.79	212.59	212.72	41688.0
2015-07-20 18:00:00	SPY	ETF	212.69	212.69	212.58	212.6	94604.0
2015-07-20 18:30:00	SPY	ETF	212.59	212.64	212.55	212.64	25119.0
2015-07-20 19:00:00	SPY	ETF	212.63	212.66	212.62	212.643	12386.0
2015-07-20 19:30:00	SPY	ETF	212.67	212.69	212.64	212.69	12731.0
2015-07-20 04:00:00	QQQ	ETF	113.56	113.7	113.56	113.7	1200.0
2015-07-20 04:30:00	QQQ	ETF	113.58	113.58	113.58	113.58	80000.0
2015-07-20 07:00:00	QQQ	ETF	113.7	113.7	113.5	113.5	1450.0
2015-07-20 07:30:00	QQQ	ETF	113.71	113.79	113.71	113.77	25590.0
2015-07-20 08:00:00	QQQ	ETF	113.79	113.85	113.76	113.85	92642.0
2015-07-20 08:30:00	QQQ	ETF	113.84	113.84	113.78	113.8	41949.0
2015-07-20 09:00:00	QQQ	ETF	113.83	114.01	113.82	113.82	259148.0
2015-07-20 09:30:00	QQQ	ETF	113.82	113.85	113.52	113.701	3196438.0
2015-07-20 10:00:00	QQQ	ETF	113.71	113.71	113.48	113.65	1621347.0
2015-07-20 10:30:00	QQQ	ETF	113.64	113.93	113.6101	113.9	1473552.0
2015-07-20 11:00:00	QQQ	ETF	113.9	114.049	113.9	113.95	1853360.0
2015-07-20 11:30:00	QQQ	ETF	113.96	113.99	113.87	113.97	1668121.0
2015-07-20 12:00:00	QQQ	ETF	113.97	114.05	113.9	113.941	1223229.0
2015-07-20 12:30:00	QQQ	ETF	113.95	114.11	113.94	114.08	1467291.0
2015-07-20 13:00:00	QQQ	ETF	114.08	114.225	114.07	114.22	1157237.0
2015-07-20 13:30:00	QQQ	ETF	114.21	114.21	114.05	114.08	1161305.0
2015-07-20 14:00:00	QQQ	ETF	114.08	114.33	114.05	114.28	876515.0
2015-07-20 14:30:00	QQQ	ETF	114.28	114.34	114.2551	114.3	1337344.0

> showing 50 of 13,029 rows — these rows as CSV

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