PREVIEW / etf_30min / 2019-01-31

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-31.parquet
  size:    516 KB
  rows:    17,884

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-01-31 04:00:00	SPY	ETF	268.16	268.39	268.1	268.1	14825.0
2019-01-31 04:30:00	SPY	ETF	268.1	268.15	268.04	268.05	6218.0
2019-01-31 05:00:00	SPY	ETF	268.01	268.04	267.79	267.79	9866.0
2019-01-31 05:30:00	SPY	ETF	267.78	268.19	267.78	268.0	7333.0
2019-01-31 06:00:00	SPY	ETF	268.03	268.2	267.92	268.16	31037.0
2019-01-31 06:30:00	SPY	ETF	268.2	268.3	268.11	268.3	17520.0
2019-01-31 07:00:00	SPY	ETF	268.28	268.28	267.89	268.11	104010.0
2019-01-31 07:30:00	SPY	ETF	268.1	268.28	267.83	268.16	251317.0
2019-01-31 08:00:00	SPY	ETF	268.13	268.56	267.7	267.81	213688.0
2019-01-31 08:30:00	SPY	ETF	267.75	267.92	267.52	267.74	335473.0
2019-01-31 09:00:00	SPY	ETF	267.7	267.79	267.21	267.51	477401.0
2019-01-31 09:30:00	SPY	ETF	267.51	268.03	267.27	267.95	7644902.0
2019-01-31 10:00:00	SPY	ETF	267.96	269.11	267.88	269.06	6905004.0
2019-01-31 10:30:00	SPY	ETF	269.06	269.45	268.77	269.0	6018588.0
2019-01-31 11:00:00	SPY	ETF	269.0034	269.49	268.92	269.415	4453031.0
2019-01-31 11:30:00	SPY	ETF	269.41	270.39	269.29	270.2841	7170482.0
2019-01-31 12:00:00	SPY	ETF	270.28	270.47	269.72	269.72	5667347.0
2019-01-31 12:30:00	SPY	ETF	269.7289	270.05	269.29	269.47	5212053.0
2019-01-31 13:00:00	SPY	ETF	269.4868	269.77	269.29	269.39	2749311.0
2019-01-31 13:30:00	SPY	ETF	269.4	269.7	269.17	269.69	2801042.0
2019-01-31 14:00:00	SPY	ETF	269.69	269.89	269.3201	269.4849	3185954.0
2019-01-31 14:30:00	SPY	ETF	269.4899	269.81	269.27	269.65	2129700.0
2019-01-31 15:00:00	SPY	ETF	269.65	269.66	268.95	269.33	6071590.0
2019-01-31 15:30:00	SPY	ETF	269.33	270.34	269.25	269.89	16135690.0
2019-01-31 16:00:00	SPY	ETF	269.86	270.49	269.66	270.25	21900800.0
2019-01-31 16:30:00	SPY	ETF	270.29	270.88	269.93	270.76	723290.0
2019-01-31 17:00:00	SPY	ETF	270.82	271.0	270.75	270.81	218306.0
2019-01-31 17:30:00	SPY	ETF	270.83	270.84	269.93	270.51	293787.0
2019-01-31 18:00:00	SPY	ETF	270.52	270.52	270.14	270.14	181753.0
2019-01-31 18:30:00	SPY	ETF	270.15	270.24	269.95	270.04	74349.0
2019-01-31 19:00:00	SPY	ETF	270.1	270.65	270.08	270.48	63967.0
2019-01-31 19:30:00	SPY	ETF	270.51	270.64	270.31	270.42	64074.0
2019-01-31 04:00:00	QQQ	ETF	167.07	167.12	166.95	166.95	27480.0
2019-01-31 04:30:00	QQQ	ETF	166.91	167.01	166.85	166.87	13933.0
2019-01-31 05:00:00	QQQ	ETF	166.93	166.93	166.7	166.7	9300.0
2019-01-31 05:30:00	QQQ	ETF	166.69	167.03	166.69	166.95	8197.0
2019-01-31 06:00:00	QQQ	ETF	166.86	166.97	166.85	166.97	2281.0
2019-01-31 06:30:00	QQQ	ETF	167.05	167.19	167.05	167.19	18144.0
2019-01-31 07:00:00	QQQ	ETF	167.17	167.29	167.01	167.23	47471.0
2019-01-31 07:30:00	QQQ	ETF	167.24	167.35	167.08	167.24	90966.0
2019-01-31 08:00:00	QQQ	ETF	167.11	167.34	165.68	166.96	89890.0
2019-01-31 08:30:00	QQQ	ETF	166.93	167.02	166.71	166.8201	82439.0
2019-01-31 09:00:00	QQQ	ETF	166.82	166.83	166.44	166.67	259877.0
2019-01-31 09:30:00	QQQ	ETF	166.65	167.41	166.4701	167.32	4286399.0
2019-01-31 10:00:00	QQQ	ETF	167.33	168.0399	167.21	167.87	2825190.0
2019-01-31 10:30:00	QQQ	ETF	167.885	168.25	167.74	167.91	2455331.0
2019-01-31 11:00:00	QQQ	ETF	167.9	168.2	167.8501	168.071	1210704.0
2019-01-31 11:30:00	QQQ	ETF	168.07	168.96	167.94	168.825	2188973.0
2019-01-31 12:00:00	QQQ	ETF	168.815	168.99	168.46	168.5	1982931.0
2019-01-31 12:30:00	QQQ	ETF	168.5	168.67	168.15	168.35	1529032.0

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

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