PREVIEW / etf_30min / 2015-06-11

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-11.parquet
  size:    364 KB
  rows:    12,489

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-11 04:00:00	SPY	ETF	211.19	211.27	211.16	211.17	14018.0
2015-06-11 04:30:00	SPY	ETF	211.05	211.18	211.04	211.11	12377.0
2015-06-11 05:00:00	SPY	ETF	211.2	211.23	211.14	211.14	4800.0
2015-06-11 05:30:00	SPY	ETF	211.14	211.26	211.14	211.14	4401.0
2015-06-11 06:00:00	SPY	ETF	211.19	211.21	211.14	211.16	4700.0
2015-06-11 06:30:00	SPY	ETF	211.14	211.24	211.09	211.24	6400.0
2015-06-11 07:00:00	SPY	ETF	211.21	211.25	211.13	211.25	27130.0
2015-06-11 07:30:00	SPY	ETF	211.25	211.53	211.2	211.48	165533.0
2015-06-11 08:00:00	SPY	ETF	211.48	211.58	211.19	211.44	343641.0
2015-06-11 08:30:00	SPY	ETF	211.49	211.59	211.34	211.48	364048.0
2015-06-11 09:00:00	SPY	ETF	211.48	211.66	211.38	211.51	585802.0
2015-06-11 09:30:00	SPY	ETF	211.48	211.975	211.41	211.93	9703272.0
2015-06-11 10:00:00	SPY	ETF	211.93	212.09	211.82	211.86	5294097.0
2015-06-11 10:30:00	SPY	ETF	211.87	211.88	211.2	211.305	9738612.0
2015-06-11 11:00:00	SPY	ETF	211.3046	211.695	211.22	211.5	4693245.0
2015-06-11 11:30:00	SPY	ETF	211.5	211.72	211.44	211.55	2645180.0
2015-06-11 12:00:00	SPY	ETF	211.56	211.66	211.38	211.5349	3330057.0
2015-06-11 12:30:00	SPY	ETF	211.53	211.7	211.51	211.62	2369115.0
2015-06-11 13:00:00	SPY	ETF	211.621	211.64	211.49	211.6	1702135.0
2015-06-11 13:30:00	SPY	ETF	211.61	211.87	211.551	211.755	2700060.0
2015-06-11 14:00:00	SPY	ETF	211.765	211.82	211.67	211.71	3515319.0
2015-06-11 14:30:00	SPY	ETF	211.715	211.79	211.56	211.64	2735328.0
2015-06-11 15:00:00	SPY	ETF	211.6384	211.76	211.54	211.6	3954604.0
2015-06-11 15:30:00	SPY	ETF	211.6	211.68	211.29	211.6	12488656.0
2015-06-11 16:00:00	SPY	ETF	211.59	211.74	211.4614	211.55	5614903.0
2015-06-11 16:30:00	SPY	ETF	211.54	211.63	211.51	211.59	831427.0
2015-06-11 17:00:00	SPY	ETF	211.6	211.65	211.6	211.65	21041.0
2015-06-11 17:30:00	SPY	ETF	211.63	211.65	211.55	211.55	45751.0
2015-06-11 18:00:00	SPY	ETF	211.55	211.55	211.36	211.44	50979.0
2015-06-11 18:30:00	SPY	ETF	211.45	211.46	211.4	211.44	4815.0
2015-06-11 19:00:00	SPY	ETF	211.44	211.45	211.4	211.41	2450.0
2015-06-11 19:30:00	SPY	ETF	211.44	211.44	211.37	211.39	36026.0
2015-06-11 06:00:00	QQQ	ETF	109.59	109.6	109.58	109.58	2200.0
2015-06-11 06:30:00	QQQ	ETF	109.56	109.6	109.55	109.58	1200.0
2015-06-11 07:00:00	QQQ	ETF	109.6	109.63	109.58	109.58	10200.0
2015-06-11 07:30:00	QQQ	ETF	109.64	109.76	109.63	109.75	65603.0
2015-06-11 08:00:00	QQQ	ETF	109.75	109.81	109.75	109.78	54350.0
2015-06-11 08:30:00	QQQ	ETF	109.76	109.86	109.75	109.75	41187.0
2015-06-11 09:00:00	QQQ	ETF	109.79	109.88	109.75	109.85	105426.0
2015-06-11 09:30:00	QQQ	ETF	109.86	110.15	109.78	110.1	2640264.0
2015-06-11 10:00:00	QQQ	ETF	110.1	110.15	109.88	109.92	1482103.0
2015-06-11 10:30:00	QQQ	ETF	109.91	109.92	109.54	109.65	2003022.0
2015-06-11 11:00:00	QQQ	ETF	109.645	109.87	109.59	109.69	1453438.0
2015-06-11 11:30:00	QQQ	ETF	109.69	109.8	109.66	109.67	588803.0
2015-06-11 12:00:00	QQQ	ETF	109.67	109.755	109.46	109.6	718525.0
2015-06-11 12:30:00	QQQ	ETF	109.605	109.69	109.57	109.67	445993.0
2015-06-11 13:00:00	QQQ	ETF	109.65	109.68	109.57	109.65	936061.0
2015-06-11 13:30:00	QQQ	ETF	109.655	109.83	109.61	109.75	802436.0
2015-06-11 14:00:00	QQQ	ETF	109.7499	109.79	109.68	109.71	393767.0
2015-06-11 14:30:00	QQQ	ETF	109.7001	109.77	109.63	109.66	375596.0

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

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