PREVIEW / etf_30min / 2019-03-13

all etf 30-min files

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

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-13 04:00:00	SPY	ETF	279.27	279.43	279.27	279.43	2150.0
2019-03-13 04:30:00	SPY	ETF	279.56	279.63	279.56	279.58	4500.0
2019-03-13 05:00:00	SPY	ETF	279.6	279.67	279.6	279.67	2200.0
2019-03-13 05:30:00	SPY	ETF	279.71	279.71	279.55	279.55	1100.0
2019-03-13 06:00:00	SPY	ETF	279.61	279.8	279.61	279.78	5430.0
2019-03-13 06:30:00	SPY	ETF	279.75	279.92	279.68	279.92	24598.0
2019-03-13 07:00:00	SPY	ETF	279.87	279.97	279.84	279.86	31886.0
2019-03-13 07:30:00	SPY	ETF	279.86	280.1	279.86	280.08	64316.0
2019-03-13 08:00:00	SPY	ETF	280.0199	280.32	278.9	280.21	125702.0
2019-03-13 08:30:00	SPY	ETF	280.29	280.32	279.99	280.05	203822.0
2019-03-13 09:00:00	SPY	ETF	280.05	280.5	280.03	280.49	242194.0
2019-03-13 09:30:00	SPY	ETF	280.48	280.94	280.3	280.83	6307305.0
2019-03-13 10:00:00	SPY	ETF	280.82	281.15	280.8	280.87	4031810.0
2019-03-13 10:30:00	SPY	ETF	280.87	281.43	280.865	281.33	4888779.0
2019-03-13 11:00:00	SPY	ETF	281.34	281.99	281.33	281.98	6704718.0
2019-03-13 11:30:00	SPY	ETF	281.98	282.1	281.67	281.81	6620109.0
2019-03-13 12:00:00	SPY	ETF	281.8115	282.0	281.491	281.64	5018029.0
2019-03-13 12:30:00	SPY	ETF	281.63	281.88	281.49	281.81	3462507.0
2019-03-13 13:00:00	SPY	ETF	281.82	282.02	281.78	281.905	2272794.0
2019-03-13 13:30:00	SPY	ETF	281.9033	282.02	281.7	282.02	2130038.0
2019-03-13 14:00:00	SPY	ETF	282.03	282.38	281.97	282.08	3714179.0
2019-03-13 14:30:00	SPY	ETF	282.08	282.08	281.11	281.65	6878587.0
2019-03-13 15:00:00	SPY	ETF	281.62	281.71	281.13	281.33	4155875.0
2019-03-13 15:30:00	SPY	ETF	281.33	281.74	281.18	281.34	10009110.0
2019-03-13 16:00:00	SPY	ETF	281.33	281.72	281.2511	281.68	10306640.0
2019-03-13 16:30:00	SPY	ETF	281.68	281.83	281.34	281.79	1900301.0
2019-03-13 17:00:00	SPY	ETF	281.78	281.87	281.72	281.79	44070.0
2019-03-13 17:30:00	SPY	ETF	281.78	281.82	281.74	281.82	50966.0
2019-03-13 18:00:00	SPY	ETF	281.8	282.02	281.67	282.0	334110.0
2019-03-13 18:30:00	SPY	ETF	281.99	282.07	281.96	282.0	34987.0
2019-03-13 19:00:00	SPY	ETF	281.95	281.95	281.75	281.82	37117.0
2019-03-13 19:30:00	SPY	ETF	281.84	281.85	281.59	281.73	75289.0
2019-03-13 04:00:00	QQQ	ETF	175.67	175.82	175.67	175.82	3434.0
2019-03-13 04:30:00	QQQ	ETF	175.87	175.95	175.87	175.94	5337.0
2019-03-13 05:00:00	QQQ	ETF	175.97	175.97	175.89	175.93	8900.0
2019-03-13 05:30:00	QQQ	ETF	175.93	176.04	175.86	175.86	10240.0
2019-03-13 06:00:00	QQQ	ETF	175.91	176.03	175.91	176.03	16200.0
2019-03-13 06:30:00	QQQ	ETF	176.04	176.08	175.94	176.06	10900.0
2019-03-13 07:00:00	QQQ	ETF	176.06	176.14	176.02	176.08	22879.0
2019-03-13 07:30:00	QQQ	ETF	176.07	176.39	176.06	176.39	42506.0
2019-03-13 08:00:00	QQQ	ETF	176.28	176.61	175.55	176.46	129701.0
2019-03-13 08:30:00	QQQ	ETF	176.49	176.5	176.26	176.26	75840.0
2019-03-13 09:00:00	QQQ	ETF	176.27	176.66	176.25	176.59	136832.0
2019-03-13 09:30:00	QQQ	ETF	176.6	176.97	176.35	176.7675	2539502.0
2019-03-13 10:00:00	QQQ	ETF	176.77	176.86	176.53	176.58	1630207.0
2019-03-13 10:30:00	QQQ	ETF	176.58	177.16	176.56	177.1	2171785.0
2019-03-13 11:00:00	QQQ	ETF	177.1	177.65	177.09	177.59	2812246.0
2019-03-13 11:30:00	QQQ	ETF	177.6	177.68	177.38	177.4401	1907314.0
2019-03-13 12:00:00	QQQ	ETF	177.45	177.6	177.26	177.36	1155370.0
2019-03-13 12:30:00	QQQ	ETF	177.36	177.52	177.26	177.4081	880409.0

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

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