PREVIEW / etf_30min / 2019-03-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-18.parquet
  size:    490 KB
  rows:    17,367

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
2019-03-18 04:00:00	SPY	ETF	281.71	281.72	281.58	281.6	4991.0
2019-03-18 04:30:00	SPY	ETF	281.64	281.81	281.64	281.72	12697.0
2019-03-18 05:00:00	SPY	ETF	281.67	281.71	281.47	281.49	13734.0
2019-03-18 05:30:00	SPY	ETF	281.46	281.54	281.43	281.52	5470.0
2019-03-18 06:00:00	SPY	ETF	281.54	281.6	281.4	281.4	5935.0
2019-03-18 06:30:00	SPY	ETF	281.5	281.67	281.5	281.58	7497.0
2019-03-18 07:00:00	SPY	ETF	281.56	281.91	281.56	281.81	61940.0
2019-03-18 07:30:00	SPY	ETF	281.78	281.98	281.78	281.9	28075.0
2019-03-18 08:00:00	SPY	ETF	281.74	281.92	281.56	281.73	149185.0
2019-03-18 08:30:00	SPY	ETF	281.76	281.8	281.63	281.63	81610.0
2019-03-18 09:00:00	SPY	ETF	281.65	281.67	281.5	281.51	135073.0
2019-03-18 09:30:00	SPY	ETF	281.55	282.43	281.53	282.42	7261797.0
2019-03-18 10:00:00	SPY	ETF	282.425	282.623	282.14	282.37	4015098.0
2019-03-18 10:30:00	SPY	ETF	282.365	282.66	282.08	282.5	3410214.0
2019-03-18 11:00:00	SPY	ETF	282.5	282.55	281.5	281.67	4053914.0
2019-03-18 11:30:00	SPY	ETF	281.66	281.8185	281.3	281.59	3651763.0
2019-03-18 12:00:00	SPY	ETF	281.61	281.73	281.4301	281.67	3684807.0
2019-03-18 12:30:00	SPY	ETF	281.67	282.03	281.465	281.9321	2079865.0
2019-03-18 13:00:00	SPY	ETF	281.93	282.01	281.82	281.92	1312373.0
2019-03-18 13:30:00	SPY	ETF	281.92	282.18	281.86	282.11	2080153.0
2019-03-18 14:00:00	SPY	ETF	282.1	282.19	281.94	282.065	1649589.0
2019-03-18 14:30:00	SPY	ETF	282.06	282.29	281.98	282.155	2016582.0
2019-03-18 15:00:00	SPY	ETF	282.16	282.18	281.84	281.935	5924370.0
2019-03-18 15:30:00	SPY	ETF	281.935	282.56	281.935	282.39	11977831.0
2019-03-18 16:00:00	SPY	ETF	282.39	282.67	282.3049	282.6	6988050.0
2019-03-18 16:30:00	SPY	ETF	282.6	282.7	282.33	282.65	250274.0
2019-03-18 17:00:00	SPY	ETF	282.66	282.68	282.58	282.6199	79323.0
2019-03-18 17:30:00	SPY	ETF	282.61	282.62	282.33	282.61	242869.0
2019-03-18 18:00:00	SPY	ETF	282.62	282.83	282.62	282.83	92348.0
2019-03-18 18:30:00	SPY	ETF	282.81	282.81	282.61	282.67	17596.0
2019-03-18 19:00:00	SPY	ETF	282.66	282.73	282.58	282.69	7907.0
2019-03-18 19:30:00	SPY	ETF	282.68	282.75	282.62	282.68	26141.0
2019-03-18 04:00:00	QQQ	ETF	178.34	178.42	178.27	178.32	3600.0
2019-03-18 04:30:00	QQQ	ETF	178.35	178.43	178.35	178.37	838.0
2019-03-18 05:00:00	QQQ	ETF	178.36	178.4	178.23	178.25	9260.0
2019-03-18 05:30:00	QQQ	ETF	178.22	178.29	178.22	178.28	25500.0
2019-03-18 06:00:00	QQQ	ETF	178.27	178.3	178.13	178.18	16535.0
2019-03-18 06:30:00	QQQ	ETF	178.21	178.29	178.2	178.22	5678.0
2019-03-18 07:00:00	QQQ	ETF	178.24	178.45	178.21	178.3	30477.0
2019-03-18 07:30:00	QQQ	ETF	178.29	178.37	178.29	178.35	13047.0
2019-03-18 08:00:00	QQQ	ETF	178.33	178.45	178.18	178.2	64663.0
2019-03-18 08:30:00	QQQ	ETF	178.21	178.22	178.08	178.09	58529.0
2019-03-18 09:00:00	QQQ	ETF	178.08	178.09	177.89	177.95	153948.0
2019-03-18 09:30:00	QQQ	ETF	177.95	178.74	177.94	178.74	3055361.0
2019-03-18 10:00:00	QQQ	ETF	178.74	178.91	178.59	178.71	2187410.0
2019-03-18 10:30:00	QQQ	ETF	178.72	178.99	178.48	178.85	2124262.0
2019-03-18 11:00:00	QQQ	ETF	178.85	178.87	177.92	178.08	1935543.0
2019-03-18 11:30:00	QQQ	ETF	178.08	178.08	177.72	177.91	2074859.0
2019-03-18 12:00:00	QQQ	ETF	177.92	178.01	177.5915	177.81	2170741.0
2019-03-18 12:30:00	QQQ	ETF	177.8099	178.11	177.66	178.01	1063509.0

> showing 50 of 17,367 rows — these rows as CSV

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