PREVIEW / etf_30min / 2019-03-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-27.parquet
  size:    492 KB
  rows:    17,297

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-27 04:00:00	SPY	ETF	281.77	281.78	281.25	281.25	5883.0
2019-03-27 04:30:00	SPY	ETF	281.34	281.35	281.29	281.3	5113.0
2019-03-27 05:00:00	SPY	ETF	281.22	281.55	281.22	281.55	1645.0
2019-03-27 05:30:00	SPY	ETF	281.61	281.67	280.79	280.85	9206.0
2019-03-27 06:00:00	SPY	ETF	280.7	280.7	280.42	280.7	48298.0
2019-03-27 06:30:00	SPY	ETF	280.72	280.72	280.24	280.24	20342.0
2019-03-27 07:00:00	SPY	ETF	280.25	280.6	280.15	280.5	91722.0
2019-03-27 07:30:00	SPY	ETF	280.52	280.75	280.45	280.65	46645.0
2019-03-27 08:00:00	SPY	ETF	280.7	281.77	280.1901	280.72	234743.0
2019-03-27 08:30:00	SPY	ETF	280.75	281.21	280.64	281.12	222769.0
2019-03-27 09:00:00	SPY	ETF	281.08	281.25	280.98	281.12	221397.0
2019-03-27 09:30:00	SPY	ETF	281.11	281.76	280.5415	280.69	5757871.0
2019-03-27 10:00:00	SPY	ETF	280.695	281.56	280.47	281.31	3951697.0
2019-03-27 10:30:00	SPY	ETF	281.31	281.47	279.78	280.12	6043537.0
2019-03-27 11:00:00	SPY	ETF	280.12	280.35	278.86	278.9	4922851.0
2019-03-27 11:30:00	SPY	ETF	278.89	279.07	277.93	278.35	8140634.0
2019-03-27 12:00:00	SPY	ETF	278.34	279.04	278.12	278.95	4209657.0
2019-03-27 12:30:00	SPY	ETF	278.96	279.34	278.85	278.97	3894859.0
2019-03-27 13:00:00	SPY	ETF	278.96	279.87	278.67	279.73	4255879.0
2019-03-27 13:30:00	SPY	ETF	279.72	280.01	279.46	279.76	3683087.0
2019-03-27 14:00:00	SPY	ETF	279.77	280.2	279.62	279.885	3138077.0
2019-03-27 14:30:00	SPY	ETF	279.88	280.16	279.41	279.69	3225680.0
2019-03-27 15:00:00	SPY	ETF	279.7	280.0189	279.38	279.985	3598738.0
2019-03-27 15:30:00	SPY	ETF	279.99	280.35	279.51	279.72	10776008.0
2019-03-27 16:00:00	SPY	ETF	279.72	279.96	279.55	279.78	4073139.0
2019-03-27 16:30:00	SPY	ETF	279.77	279.8	279.47	279.47	333085.0
2019-03-27 17:00:00	SPY	ETF	279.45	279.55	279.44	279.54	58608.0
2019-03-27 17:30:00	SPY	ETF	279.54	279.56	279.49	279.54	24192.0
2019-03-27 18:00:00	SPY	ETF	279.5	279.54	279.2	279.21	48939.0
2019-03-27 18:30:00	SPY	ETF	279.28	279.35	279.24	279.35	12750.0
2019-03-27 19:00:00	SPY	ETF	279.31	279.46	279.16	279.16	8194.0
2019-03-27 19:30:00	SPY	ETF	279.23	279.42	279.14	279.37	38397.0
2019-03-27 04:00:00	QQQ	ETF	179.63	179.63	179.31	179.31	10346.0
2019-03-27 04:30:00	QQQ	ETF	179.31	179.41	179.31	179.35	5300.0
2019-03-27 05:00:00	QQQ	ETF	179.37	179.54	179.35	179.54	8128.0
2019-03-27 05:30:00	QQQ	ETF	179.59	179.6	179.06	179.09	14106.0
2019-03-27 06:00:00	QQQ	ETF	179.08	179.08	178.85	179.02	10384.0
2019-03-27 06:30:00	QQQ	ETF	178.86	178.95	178.75	178.75	4050.0
2019-03-27 07:00:00	QQQ	ETF	178.8	178.94	178.72	178.88	27862.0
2019-03-27 07:30:00	QQQ	ETF	178.87	179.06	178.85	178.99	16686.0
2019-03-27 08:00:00	QQQ	ETF	178.71	179.54	178.7	178.98	96277.0
2019-03-27 08:30:00	QQQ	ETF	179.05	179.33	178.98	179.24	115670.0
2019-03-27 09:00:00	QQQ	ETF	179.23	179.36	179.16	179.28	84980.0
2019-03-27 09:30:00	QQQ	ETF	179.27	179.72	178.73	178.82	4077499.0
2019-03-27 10:00:00	QQQ	ETF	178.82	179.5	178.66	179.3	2028104.0
2019-03-27 10:30:00	QQQ	ETF	179.31	179.45	178.23	178.55	2979181.0
2019-03-27 11:00:00	QQQ	ETF	178.53	178.73	177.33	177.37	2295814.0
2019-03-27 11:30:00	QQQ	ETF	177.34	177.49	176.6	176.88	4318073.0
2019-03-27 12:00:00	QQQ	ETF	176.87	177.45	176.74	177.39	2329575.0
2019-03-27 12:30:00	QQQ	ETF	177.39	177.67	177.31	177.34	1439377.0

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

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