PREVIEW / etf_30min / 2019-05-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-14.parquet
  size:    505 KB
  rows:    17,535

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-05-14 04:00:00	SPY	ETF	281.77	282.0	281.44	281.59	9357.0
2019-05-14 04:30:00	SPY	ETF	281.53	281.88	281.44	281.88	15428.0
2019-05-14 05:00:00	SPY	ETF	281.85	282.05	281.75	282.05	2160.0
2019-05-14 05:30:00	SPY	ETF	282.1	282.37	282.08	282.29	12072.0
2019-05-14 06:00:00	SPY	ETF	282.29	282.55	282.11	282.47	42029.0
2019-05-14 06:30:00	SPY	ETF	282.44	282.82	282.2	282.34	104062.0
2019-05-14 07:00:00	SPY	ETF	282.28	282.85	282.2	282.62	328715.0
2019-05-14 07:30:00	SPY	ETF	282.66	282.66	282.41	282.56	254212.0
2019-05-14 08:00:00	SPY	ETF	282.29	282.84	281.68	282.38	287713.0
2019-05-14 08:30:00	SPY	ETF	282.36	282.36	281.87	282.27	514378.0
2019-05-14 09:00:00	SPY	ETF	282.28	282.38	280.86	282.02	481769.0
2019-05-14 09:30:00	SPY	ETF	281.99	282.97	281.85	282.36	7578212.0
2019-05-14 10:00:00	SPY	ETF	282.37	283.59	282.36	283.44	7549751.0
2019-05-14 10:30:00	SPY	ETF	283.44	283.68	283.1	283.39	4989110.0
2019-05-14 11:00:00	SPY	ETF	283.39	284.29	283.07	284.02	5519267.0
2019-05-14 11:30:00	SPY	ETF	284.015	284.73	283.98	284.54	4515009.0
2019-05-14 12:00:00	SPY	ETF	284.54	284.77	284.13	284.16	4012304.0
2019-05-14 12:30:00	SPY	ETF	284.16	284.55	284.03	284.32	2824410.0
2019-05-14 13:00:00	SPY	ETF	284.325	284.99	284.325	284.85	2522285.0
2019-05-14 13:30:00	SPY	ETF	284.85	285.1	284.84	284.86	2199001.0
2019-05-14 14:00:00	SPY	ETF	284.86	285.05	284.3	284.8852	3693074.0
2019-05-14 14:30:00	SPY	ETF	284.88	284.96	284.03	284.315	5040978.0
2019-05-14 15:00:00	SPY	ETF	284.31	284.77	284.14	284.39	4130563.0
2019-05-14 15:30:00	SPY	ETF	284.38	284.38	283.17	283.33	13592319.0
2019-05-14 16:00:00	SPY	ETF	283.32	283.7	283.27	283.65	2832505.0
2019-05-14 16:30:00	SPY	ETF	283.65	283.82	283.2858	283.72	305976.0
2019-05-14 17:00:00	SPY	ETF	283.73	283.73	283.4	283.65	106395.0
2019-05-14 17:30:00	SPY	ETF	283.61	283.73	283.52	283.73	100087.0
2019-05-14 18:00:00	SPY	ETF	283.73	284.0	283.4	283.96	122936.0
2019-05-14 18:30:00	SPY	ETF	283.96	283.99	283.83	283.85	8146.0
2019-05-14 19:00:00	SPY	ETF	283.85	283.93	283.71	283.87	18864.0
2019-05-14 19:30:00	SPY	ETF	283.86	283.91	283.72	283.91	26640.0
2019-05-14 04:00:00	QQQ	ETF	179.05	179.43	179.05	179.19	71597.0
2019-05-14 04:30:00	QQQ	ETF	179.1	179.43	179.1	179.42	7902.0
2019-05-14 05:00:00	QQQ	ETF	179.42	179.66	179.37	179.55	25681.0
2019-05-14 05:30:00	QQQ	ETF	179.63	179.8	179.57	179.72	19978.0
2019-05-14 06:00:00	QQQ	ETF	179.72	179.96	179.6	179.96	19734.0
2019-05-14 06:30:00	QQQ	ETF	179.81	180.05	179.67	179.75	101279.0
2019-05-14 07:00:00	QQQ	ETF	179.7	180.16	179.7	180.06	157262.0
2019-05-14 07:30:00	QQQ	ETF	180.06	180.06	179.8	179.91	234125.0
2019-05-14 08:00:00	QQQ	ETF	179.75	180.15	179.0	179.71	225565.0
2019-05-14 08:30:00	QQQ	ETF	179.62	179.79	179.14	179.76	231558.0
2019-05-14 09:00:00	QQQ	ETF	179.76	179.85	179.34	179.5	247161.0
2019-05-14 09:30:00	QQQ	ETF	179.5	180.06	178.86	179.27	5376379.0
2019-05-14 10:00:00	QQQ	ETF	179.27	180.4401	179.25	180.3299	4075340.0
2019-05-14 10:30:00	QQQ	ETF	180.32	180.54	180.03	180.27	2719257.0
2019-05-14 11:00:00	QQQ	ETF	180.27	181.08	179.91	180.845	2886109.0
2019-05-14 11:30:00	QQQ	ETF	180.84	181.32	180.79	181.15	2394976.0
2019-05-14 12:00:00	QQQ	ETF	181.16	181.47	180.84	180.88	2211239.0
2019-05-14 12:30:00	QQQ	ETF	180.88	181.27	180.82	181.075	1054632.0

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

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