PREVIEW / etf_30min / 2015-03-31

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-31.parquet
  size:    375 KB
  rows:    12,708

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-03-31 04:00:00	SPY	ETF	207.79	207.8	207.64	207.72	22793.0
2015-03-31 04:30:00	SPY	ETF	207.7	207.71	207.64	207.64	4600.0
2015-03-31 05:00:00	SPY	ETF	207.64	207.64	207.27	207.46	29427.0
2015-03-31 05:30:00	SPY	ETF	207.33	207.33	206.97	207.06	21573.0
2015-03-31 06:00:00	SPY	ETF	207.03	207.03	206.83	206.83	61213.0
2015-03-31 06:30:00	SPY	ETF	206.88	206.99	206.86	206.86	205520.0
2015-03-31 07:00:00	SPY	ETF	206.83	206.89	206.71	206.89	225740.0
2015-03-31 07:30:00	SPY	ETF	206.88	207.08	206.87	206.99	202239.0
2015-03-31 08:00:00	SPY	ETF	206.99	208.02	206.74	206.94	494038.0
2015-03-31 08:30:00	SPY	ETF	206.95	207.18	206.95	207.12	453905.0
2015-03-31 09:00:00	SPY	ETF	207.1	207.27	206.95	207.26	579164.0
2015-03-31 09:30:00	SPY	ETF	207.26	207.56	206.97	207.355	13245226.0
2015-03-31 10:00:00	SPY	ETF	207.35	207.73	207.3	207.6	6595497.0
2015-03-31 10:30:00	SPY	ETF	207.6	207.86	207.55	207.55	3125156.0
2015-03-31 11:00:00	SPY	ETF	207.55	208.1	207.53	207.865	4581788.0
2015-03-31 11:30:00	SPY	ETF	207.87	207.89	207.37	207.38	4823348.0
2015-03-31 12:00:00	SPY	ETF	207.38	207.44	207.14	207.38	3940452.0
2015-03-31 12:30:00	SPY	ETF	207.39	207.58	207.28	207.47	2723864.0
2015-03-31 13:00:00	SPY	ETF	207.46	207.74	207.46	207.67	2785638.0
2015-03-31 13:30:00	SPY	ETF	207.68	207.88	207.39	207.47	3836252.0
2015-03-31 14:00:00	SPY	ETF	207.47	207.64	207.4	207.46	3270562.0
2015-03-31 14:30:00	SPY	ETF	207.45	207.6	207.29	207.57	3915430.0
2015-03-31 15:00:00	SPY	ETF	207.57	207.59	206.45	206.65	15679319.0
2015-03-31 15:30:00	SPY	ETF	206.64	206.93	206.36	206.44	29235929.0
2015-03-31 16:00:00	SPY	ETF	206.44	207.24	206.14	206.38	15183165.0
2015-03-31 16:30:00	SPY	ETF	206.39	206.48	206.3	206.35	6058686.0
2015-03-31 17:00:00	SPY	ETF	206.35	206.35	206.28	206.34	1102952.0
2015-03-31 17:30:00	SPY	ETF	206.34	206.43	206.3	206.33	275066.0
2015-03-31 18:00:00	SPY	ETF	206.35	206.38	206.18	206.36	126839.0
2015-03-31 18:30:00	SPY	ETF	206.33	206.36	206.24	206.34	14688.0
2015-03-31 19:00:00	SPY	ETF	206.37	206.39	206.35	206.39	5010.0
2015-03-31 19:30:00	SPY	ETF	206.36	206.47	206.36	206.4	26679.0
2015-03-31 05:00:00	QQQ	ETF	106.35	106.35	106.35	106.35	1000.0
2015-03-31 05:30:00	QQQ	ETF	106.3	106.3	106.21	106.23	4300.0
2015-03-31 06:00:00	QQQ	ETF	106.2	106.2	106.1	106.17	30100.0
2015-03-31 06:30:00	QQQ	ETF	106.17	106.25	106.17	106.23	1700.0
2015-03-31 07:00:00	QQQ	ETF	106.08	106.15	106.08	106.12	35616.0
2015-03-31 07:30:00	QQQ	ETF	106.15	106.26	106.15	106.23	15079.0
2015-03-31 08:00:00	QQQ	ETF	106.21	106.65	106.12	106.19	60770.0
2015-03-31 08:30:00	QQQ	ETF	106.24	106.39	106.24	106.34	55763.0
2015-03-31 09:00:00	QQQ	ETF	106.33	106.42	106.28	106.42	175572.0
2015-03-31 09:30:00	QQQ	ETF	106.43	106.49	106.02	106.26	3781782.0
2015-03-31 10:00:00	QQQ	ETF	106.26	106.47	106.2	106.36	1872023.0
2015-03-31 10:30:00	QQQ	ETF	106.355	106.51	106.3049	106.35	754079.0
2015-03-31 11:00:00	QQQ	ETF	106.34	106.65	106.34	106.54	1458203.0
2015-03-31 11:30:00	QQQ	ETF	106.55	106.55	106.25	106.25	1008030.0
2015-03-31 12:00:00	QQQ	ETF	106.25	106.3089	106.1041	106.25	902754.0
2015-03-31 12:30:00	QQQ	ETF	106.26	106.35	106.2	106.33	566624.0
2015-03-31 13:00:00	QQQ	ETF	106.34	106.45	106.3267	106.401	674028.0
2015-03-31 13:30:00	QQQ	ETF	106.41	106.5	106.2	106.245	720983.0

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

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