PREVIEW / etf_30min / 2018-08-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-01.parquet
  size:    461 KB
  rows:    15,935

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
2018-08-01 04:00:00	SPY	ETF	281.37	281.5	281.16	281.29	8693.0
2018-08-01 04:30:00	SPY	ETF	281.29	281.29	281.13	281.21	5215.0
2018-08-01 05:00:00	SPY	ETF	281.11	281.11	280.96	280.96	3404.0
2018-08-01 05:30:00	SPY	ETF	280.91	281.01	280.88	280.93	11270.0
2018-08-01 06:00:00	SPY	ETF	280.95	281.31	280.95	281.31	14744.0
2018-08-01 06:30:00	SPY	ETF	281.25	281.26	280.95	280.95	9908.0
2018-08-01 07:00:00	SPY	ETF	280.96	281.08	280.96	281.06	45667.0
2018-08-01 07:30:00	SPY	ETF	281.05	281.29	281.05	281.27	26767.0
2018-08-01 08:00:00	SPY	ETF	281.31	281.71	280.98	281.28	76708.0
2018-08-01 08:30:00	SPY	ETF	281.29	281.56	281.17	281.55	145523.0
2018-08-01 09:00:00	SPY	ETF	281.5	281.71	281.48	281.5	232870.0
2018-08-01 09:30:00	SPY	ETF	281.56	281.79	281.33	281.62	5059025.0
2018-08-01 10:00:00	SPY	ETF	281.65	282.02	281.41	281.94	4156370.0
2018-08-01 10:30:00	SPY	ETF	281.94	282.13	281.8	281.835	2996744.0
2018-08-01 11:00:00	SPY	ETF	281.84	281.88	281.37	281.44	3335530.0
2018-08-01 11:30:00	SPY	ETF	281.44	281.45	280.845	280.96	3919374.0
2018-08-01 12:00:00	SPY	ETF	280.96	281.0	280.38	280.52	4107663.0
2018-08-01 12:30:00	SPY	ETF	280.52	280.87	280.37	280.74	2472686.0
2018-08-01 13:00:00	SPY	ETF	280.73	280.88	280.61	280.64	2873317.0
2018-08-01 13:30:00	SPY	ETF	280.63	280.81	280.36	280.62	2450660.0
2018-08-01 14:00:00	SPY	ETF	280.65	280.93	280.1315	280.91	4419378.0
2018-08-01 14:30:00	SPY	ETF	280.91	281.06	280.58	281.04	1834342.0
2018-08-01 15:00:00	SPY	ETF	281.05	281.09	280.8	281.04	2032239.0
2018-08-01 15:30:00	SPY	ETF	281.035	281.27	280.825	280.92	6850756.0
2018-08-01 16:00:00	SPY	ETF	280.91	280.91	280.42	280.68	4365569.0
2018-08-01 16:30:00	SPY	ETF	280.67	281.09	280.61	281.01	905127.0
2018-08-01 17:00:00	SPY	ETF	280.98	281.02	280.97	281.02	31106.0
2018-08-01 17:30:00	SPY	ETF	280.99	281.07	280.98	281.0	26943.0
2018-08-01 18:00:00	SPY	ETF	281.01	281.09	280.93	281.09	35774.0
2018-08-01 18:30:00	SPY	ETF	281.07	281.07	280.96	281.02	16200.0
2018-08-01 19:00:00	SPY	ETF	281.04	281.04	280.86	280.94	21185.0
2018-08-01 19:30:00	SPY	ETF	280.94	281.04	280.94	281.02	12010.0
2018-08-01 04:00:00	QQQ	ETF	176.72	176.73	176.55	176.61	37442.0
2018-08-01 04:30:00	QQQ	ETF	176.58	176.69	176.58	176.64	5550.0
2018-08-01 05:00:00	QQQ	ETF	176.65	176.65	176.49	176.52	9750.0
2018-08-01 05:30:00	QQQ	ETF	176.52	176.66	176.49	176.53	23115.0
2018-08-01 06:00:00	QQQ	ETF	176.56	176.72	176.52	176.71	38746.0
2018-08-01 06:30:00	QQQ	ETF	176.73	176.73	176.54	176.54	7357.0
2018-08-01 07:00:00	QQQ	ETF	176.53	176.57	176.48	176.54	52905.0
2018-08-01 07:30:00	QQQ	ETF	176.58	176.77	176.58	176.72	156803.0
2018-08-01 08:00:00	QQQ	ETF	176.5099	177.0	176.45	176.68	106943.0
2018-08-01 08:30:00	QQQ	ETF	176.69	176.76	176.45	176.76	148615.0
2018-08-01 09:00:00	QQQ	ETF	176.75	176.95	176.75	176.89	256623.0
2018-08-01 09:30:00	QQQ	ETF	176.87	177.26	176.42	177.17	4455284.0
2018-08-01 10:00:00	QQQ	ETF	177.2	177.65	176.89	177.52	2836025.0
2018-08-01 10:30:00	QQQ	ETF	177.5151	177.63	177.2	177.27	2127057.0
2018-08-01 11:00:00	QQQ	ETF	177.28	177.37	177.01	177.13	1668125.0
2018-08-01 11:30:00	QQQ	ETF	177.14	177.14	176.49	176.645	2417270.0
2018-08-01 12:00:00	QQQ	ETF	176.635	176.93	176.39	176.56	2201208.0
2018-08-01 12:30:00	QQQ	ETF	176.56	176.89	176.42	176.78	1237616.0

> showing 50 of 15,935 rows — these rows as CSV

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