PREVIEW / etf_30min / 2019-03-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-14.parquet
  size:    471 KB
  rows:    16,507

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-14 04:00:00	SPY	ETF	281.59	282.01	281.59	282.01	5354.0
2019-03-14 04:30:00	SPY	ETF	281.94	282.18	281.94	282.18	6803.0
2019-03-14 05:00:00	SPY	ETF	282.22	282.23	282.06	282.07	5164.0
2019-03-14 05:30:00	SPY	ETF	282.04	282.3	282.03	282.21	14254.0
2019-03-14 06:00:00	SPY	ETF	282.2	282.2	281.5	281.54	44745.0
2019-03-14 06:30:00	SPY	ETF	281.5	281.57	280.89	281.18	206037.0
2019-03-14 07:00:00	SPY	ETF	281.12	281.41	281.12	281.38	88373.0
2019-03-14 07:30:00	SPY	ETF	281.38	281.56	281.31	281.56	91302.0
2019-03-14 08:00:00	SPY	ETF	281.58	281.8	281.15	281.8	222049.0
2019-03-14 08:30:00	SPY	ETF	281.8	281.95	281.74	281.8	333356.0
2019-03-14 09:00:00	SPY	ETF	281.81	281.84	281.31	281.37	442502.0
2019-03-14 09:30:00	SPY	ETF	281.37	281.55	281.07	281.39	5382193.0
2019-03-14 10:00:00	SPY	ETF	281.38	281.39	280.6662	281.08	4348462.0
2019-03-14 10:30:00	SPY	ETF	281.07	281.44	280.98	281.22	4577987.0
2019-03-14 11:00:00	SPY	ETF	281.2266	281.58	281.01	281.28	4516036.0
2019-03-14 11:30:00	SPY	ETF	281.28	281.84	281.21	281.66	4444504.0
2019-03-14 12:00:00	SPY	ETF	281.66	281.77	281.31	281.4299	8685704.0
2019-03-14 12:30:00	SPY	ETF	281.425	281.62	281.35	281.42	1627157.0
2019-03-14 13:00:00	SPY	ETF	281.42	281.44	281.2225	281.31	1359673.0
2019-03-14 13:30:00	SPY	ETF	281.32	281.41	280.94	281.04	3097783.0
2019-03-14 14:00:00	SPY	ETF	281.04	281.25	280.94	281.18	2999892.0
2019-03-14 14:30:00	SPY	ETF	281.18	281.235	280.88	281.1425	3716852.0
2019-03-14 15:00:00	SPY	ETF	281.15	281.35	281.08	281.27	2888553.0
2019-03-14 15:30:00	SPY	ETF	281.2715	281.5	281.1	281.19	8060821.0
2019-03-14 16:00:00	SPY	ETF	281.19	281.4875	280.95	281.07	7765873.0
2019-03-14 16:30:00	SPY	ETF	281.08	281.17	281.01	281.06	1090020.0
2019-03-14 17:00:00	SPY	ETF	281.05	281.16	281.01	281.01	580814.0
2019-03-14 17:30:00	SPY	ETF	281.01	281.07	280.97	281.07	30433.0
2019-03-14 18:00:00	SPY	ETF	281.07	281.25	281.05	281.24	87793.0
2019-03-14 18:30:00	SPY	ETF	281.24	281.26	281.17	281.17	14234.0
2019-03-14 19:00:00	SPY	ETF	281.22	281.22	281.06	281.13	15016.0
2019-03-14 19:30:00	SPY	ETF	281.12	281.23	281.06	281.23	22703.0
2019-03-14 04:00:00	QQQ	ETF	177.46	177.58	177.46	177.58	17630.0
2019-03-14 04:30:00	QQQ	ETF	177.54	177.79	177.54	177.79	7870.0
2019-03-14 05:00:00	QQQ	ETF	177.79	177.82	177.67	177.7	8420.0
2019-03-14 05:30:00	QQQ	ETF	177.75	177.88	177.73	177.78	6700.0
2019-03-14 06:00:00	QQQ	ETF	177.75	177.75	177.32	177.39	33747.0
2019-03-14 06:30:00	QQQ	ETF	177.36	177.45	177.01	177.1	18803.0
2019-03-14 07:00:00	QQQ	ETF	177.18	177.35	177.08	177.33	87038.0
2019-03-14 07:30:00	QQQ	ETF	177.31	177.4	177.27	177.37	51859.0
2019-03-14 08:00:00	QQQ	ETF	177.4	177.5	176.82	177.48	80231.0
2019-03-14 08:30:00	QQQ	ETF	177.45	177.63	177.37	177.43	181218.0
2019-03-14 09:00:00	QQQ	ETF	177.41	177.43	177.08	177.11	208125.0
2019-03-14 09:30:00	QQQ	ETF	177.115	177.27	176.72	177.15	2222554.0
2019-03-14 10:00:00	QQQ	ETF	177.15	177.18	176.66	176.94	1699658.0
2019-03-14 10:30:00	QQQ	ETF	176.95	177.17	176.69	176.905	1595328.0
2019-03-14 11:00:00	QQQ	ETF	176.9	177.13	176.7516	176.92	1446013.0
2019-03-14 11:30:00	QQQ	ETF	176.92	177.25	176.87	177.18	1060947.0
2019-03-14 12:00:00	QQQ	ETF	177.17	177.34	176.96	177.05	1061684.0
2019-03-14 12:30:00	QQQ	ETF	177.05	177.22	177.02	177.0701	689116.0

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

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