PREVIEW / etf_30min / 2018-06-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-19.parquet
  size:    480 KB
  rows:    16,735

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-06-19 04:00:00	SPY	ETF	273.45	273.8	272.81	273.0	58891.0
2018-06-19 04:30:00	SPY	ETF	272.92	273.44	272.8	273.44	14459.0
2018-06-19 05:00:00	SPY	ETF	273.4	273.59	273.37	273.53	18629.0
2018-06-19 05:30:00	SPY	ETF	273.5	273.69	273.5	273.61	15619.0
2018-06-19 06:00:00	SPY	ETF	273.73	274.0	273.65	273.95	29310.0
2018-06-19 06:30:00	SPY	ETF	273.96	273.99	273.6	273.78	131853.0
2018-06-19 07:00:00	SPY	ETF	273.78	273.92	273.36	273.38	315106.0
2018-06-19 07:30:00	SPY	ETF	273.35	274.08	273.25	274.08	286490.0
2018-06-19 08:00:00	SPY	ETF	274.07	274.5	272.55	273.78	659260.0
2018-06-19 08:30:00	SPY	ETF	273.77	274.18	273.75	274.12	378832.0
2018-06-19 09:00:00	SPY	ETF	274.11	274.22	273.92	273.96	486735.0
2018-06-19 09:30:00	SPY	ETF	274.0	274.76	273.861	274.14	9913022.0
2018-06-19 10:00:00	SPY	ETF	274.1375	274.14	273.62	273.68	7240764.0
2018-06-19 10:30:00	SPY	ETF	273.67	274.74	273.53	274.47	9976304.0
2018-06-19 11:00:00	SPY	ETF	274.49	274.99	274.395	274.82	5133161.0
2018-06-19 11:30:00	SPY	ETF	274.82	275.27	274.63	275.05	4041660.0
2018-06-19 12:00:00	SPY	ETF	275.055	275.11	274.65	274.82	2688030.0
2018-06-19 12:30:00	SPY	ETF	274.82	274.9	274.46	274.7348	2828805.0
2018-06-19 13:00:00	SPY	ETF	274.73	274.83	274.52	274.615	3814967.0
2018-06-19 13:30:00	SPY	ETF	274.61	275.14	274.33	275.04	3545443.0
2018-06-19 14:00:00	SPY	ETF	275.04	275.5	275.04	275.27	3529242.0
2018-06-19 14:30:00	SPY	ETF	275.27	275.75	275.17	275.62	3971370.0
2018-06-19 15:00:00	SPY	ETF	275.62	275.64	275.075	275.0867	6419646.0
2018-06-19 15:30:00	SPY	ETF	275.08	275.59	275.01	275.51	8528369.0
2018-06-19 16:00:00	SPY	ETF	275.51	275.58	275.25	275.47	13293685.0
2018-06-19 16:30:00	SPY	ETF	275.46	275.56	275.42	275.51	6929446.0
2018-06-19 17:00:00	SPY	ETF	275.49	275.52	275.42	275.42	922362.0
2018-06-19 17:30:00	SPY	ETF	275.45	275.45	275.39	275.4	21595.0
2018-06-19 18:00:00	SPY	ETF	275.43	275.47	275.14	275.25	50317.0
2018-06-19 18:30:00	SPY	ETF	275.22	275.32	275.21	275.26	24956.0
2018-06-19 19:00:00	SPY	ETF	275.3	275.6	275.25	275.6	16641.0
2018-06-19 19:30:00	SPY	ETF	275.49	275.65	275.48	275.4879	93298.0
2018-06-19 04:00:00	QQQ	ETF	173.95	174.55	173.95	174.16	40305.0
2018-06-19 04:30:00	QQQ	ETF	174.19	174.61	174.14	174.55	7450.0
2018-06-19 05:00:00	QQQ	ETF	174.62	174.7	174.51	174.62	8520.0
2018-06-19 05:30:00	QQQ	ETF	174.76	174.77	174.47	174.55	36580.0
2018-06-19 06:00:00	QQQ	ETF	174.69	174.87	174.68	174.76	20050.0
2018-06-19 06:30:00	QQQ	ETF	174.76	174.76	174.61	174.64	15600.0
2018-06-19 07:00:00	QQQ	ETF	174.64	174.77	174.14	174.17	113500.0
2018-06-19 07:30:00	QQQ	ETF	174.17	174.47	174.01	174.45	148515.0
2018-06-19 08:00:00	QQQ	ETF	174.43	175.3	174.06	174.06	722599.0
2018-06-19 08:30:00	QQQ	ETF	174.04	174.47	174.03	174.39	189307.0
2018-06-19 09:00:00	QQQ	ETF	174.39	174.5	174.22	174.25	261981.0
2018-06-19 09:30:00	QQQ	ETF	174.28	175.309	174.23	174.58	4311409.0
2018-06-19 10:00:00	QQQ	ETF	174.57	174.57	173.9	173.95	3375592.0
2018-06-19 10:30:00	QQQ	ETF	173.96	174.82	173.71	174.61	4527230.0
2018-06-19 11:00:00	QQQ	ETF	174.62	175.12	174.52	175.0	2364135.0
2018-06-19 11:30:00	QQQ	ETF	174.99	175.33	174.81	175.17	1779769.0
2018-06-19 12:00:00	QQQ	ETF	175.17	175.24	174.8101	175.06	1041566.0
2018-06-19 12:30:00	QQQ	ETF	175.06	175.12	174.82	175.02	1221574.0

> showing 50 of 16,735 rows — these rows as CSV

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