PREVIEW / etf_30min / 2018-07-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-18.parquet
  size:    455 KB
  rows:    15,678

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-07-18 04:00:00	SPY	ETF	280.89	280.89	280.38	280.49	3132.0
2018-07-18 04:30:00	SPY	ETF	280.52	280.55	280.42	280.52	20100.0
2018-07-18 05:00:00	SPY	ETF	280.56	280.69	280.56	280.69	7055.0
2018-07-18 06:00:00	SPY	ETF	280.64	280.68	280.53	280.55	8602.0
2018-07-18 06:30:00	SPY	ETF	280.55	280.57	280.45	280.55	5194.0
2018-07-18 07:00:00	SPY	ETF	280.51	280.57	280.42	280.42	62246.0
2018-07-18 07:30:00	SPY	ETF	280.39	280.52	280.37	280.4	60846.0
2018-07-18 08:00:00	SPY	ETF	280.4101	280.76	280.16	280.1901	97617.0
2018-07-18 08:30:00	SPY	ETF	280.2	280.4	280.16	280.36	355155.0
2018-07-18 09:00:00	SPY	ETF	280.34	280.62	280.3	280.55	342153.0
2018-07-18 09:30:00	SPY	ETF	280.56	280.75	280.26	280.41	4544455.0
2018-07-18 10:00:00	SPY	ETF	280.41	280.5	280.06	280.3727	3332918.0
2018-07-18 10:30:00	SPY	ETF	280.37	280.49	280.0851	280.43	2023156.0
2018-07-18 11:00:00	SPY	ETF	280.43	280.74	280.34	280.72	2098181.0
2018-07-18 11:30:00	SPY	ETF	280.71	281.1046	280.68	281.05	2223173.0
2018-07-18 12:00:00	SPY	ETF	281.05	281.17	280.92	281.045	1794588.0
2018-07-18 12:30:00	SPY	ETF	281.05	281.09	280.89	280.9601	1560917.0
2018-07-18 13:00:00	SPY	ETF	280.96	281.02	280.86	280.965	1282900.0
2018-07-18 13:30:00	SPY	ETF	280.97	280.9764	280.64	280.82	1299299.0
2018-07-18 14:00:00	SPY	ETF	280.815	281.01	280.78	280.99	1956087.0
2018-07-18 14:30:00	SPY	ETF	280.99	281.09	280.86	281.0	1573629.0
2018-07-18 15:00:00	SPY	ETF	280.995	281.15	280.94	281.08	3009630.0
2018-07-18 15:30:00	SPY	ETF	281.08	281.18	280.945	281.05	8040622.0
2018-07-18 16:00:00	SPY	ETF	281.05	281.08	280.92	280.94	7347322.0
2018-07-18 16:30:00	SPY	ETF	280.93	281.06	280.84	280.87	691299.0
2018-07-18 17:00:00	SPY	ETF	280.94	280.94	280.89	280.91	104699.0
2018-07-18 17:30:00	SPY	ETF	280.91	281.06	280.89	280.91	23679.0
2018-07-18 18:00:00	SPY	ETF	280.9	280.95	280.83	280.93	64566.0
2018-07-18 18:30:00	SPY	ETF	280.91	280.97	280.91	280.97	10075.0
2018-07-18 19:00:00	SPY	ETF	280.98	281.0	280.98	280.99	2266.0
2018-07-18 19:30:00	SPY	ETF	280.96	281.05	280.96	281.03	22818.0
2018-07-18 20:00:00	SPY	ETF	281.06	281.06	281.0503	281.0503	70000.0
2018-07-18 04:00:00	QQQ	ETF	180.3	180.3	180.16	180.2	6190.0
2018-07-18 04:30:00	QQQ	ETF	180.17	180.25	180.16	180.25	5029.0
2018-07-18 05:00:00	QQQ	ETF	180.24	180.32	180.24	180.25	5400.0
2018-07-18 05:30:00	QQQ	ETF	180.34	180.35	180.28	180.34	2640.0
2018-07-18 06:00:00	QQQ	ETF	180.28	180.3	180.15	180.2	4911.0
2018-07-18 06:30:00	QQQ	ETF	180.25	180.25	180.15	180.17	6848.0
2018-07-18 07:00:00	QQQ	ETF	180.16	180.23	180.09	180.09	21590.0
2018-07-18 07:30:00	QQQ	ETF	180.09	180.16	180.05	180.11	39305.0
2018-07-18 08:00:00	QQQ	ETF	180.27	180.42	179.94	179.97	117781.0
2018-07-18 08:30:00	QQQ	ETF	180.0	180.13	179.95	180.11	60497.0
2018-07-18 09:00:00	QQQ	ETF	180.14	180.3299	180.1	180.3	131689.0
2018-07-18 09:30:00	QQQ	ETF	180.28	180.44	179.6	179.86	2813991.0
2018-07-18 10:00:00	QQQ	ETF	179.85	180.0	179.4	179.7	2489286.0
2018-07-18 10:30:00	QQQ	ETF	179.69	179.79	179.38	179.73	1345283.0
2018-07-18 11:00:00	QQQ	ETF	179.73	180.12	179.6	179.9799	1261596.0
2018-07-18 11:30:00	QQQ	ETF	179.97	180.11	179.89	180.055	972332.0
2018-07-18 12:00:00	QQQ	ETF	180.055	180.14	179.74	179.93	857390.0
2018-07-18 12:30:00	QQQ	ETF	179.94	180.115	179.85	180.03	734429.0

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

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