PREVIEW / etf_30min / 2019-01-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-07.parquet
  size:    516 KB
  rows:    18,045

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-07 04:00:00	SPY	ETF	252.6	252.72	252.25	252.3	11687.0
2019-01-07 04:30:00	SPY	ETF	252.11	252.24	251.87	251.98	10002.0
2019-01-07 05:00:00	SPY	ETF	251.95	252.3	251.87	252.3	4173.0
2019-01-07 05:30:00	SPY	ETF	252.27	252.34	251.93	252.21	15508.0
2019-01-07 06:00:00	SPY	ETF	252.22	252.25	251.7	251.9	18193.0
2019-01-07 06:30:00	SPY	ETF	251.9	252.15	251.59	252.1	56917.0
2019-01-07 07:00:00	SPY	ETF	252.08	252.45	251.91	252.25	169075.0
2019-01-07 07:30:00	SPY	ETF	252.32	252.58	252.14	252.46	95580.0
2019-01-07 08:00:00	SPY	ETF	252.1301	253.3	252.0	252.34	571790.0
2019-01-07 08:30:00	SPY	ETF	252.31	252.9815	251.96	252.08	613764.0
2019-01-07 09:00:00	SPY	ETF	252.1	252.79	252.1	252.72	498134.0
2019-01-07 09:30:00	SPY	ETF	252.69	252.9	251.69	252.53	8749311.0
2019-01-07 10:00:00	SPY	ETF	252.52	253.22	252.1	252.9	9263571.0
2019-01-07 10:30:00	SPY	ETF	252.89	254.2	252.88	253.9101	7088451.0
2019-01-07 11:00:00	SPY	ETF	253.91	254.33	253.73	254.04	6298268.0
2019-01-07 11:30:00	SPY	ETF	254.04	255.42	253.83	255.4	9676947.0
2019-01-07 12:00:00	SPY	ETF	255.38	255.45	254.77	255.265	4423976.0
2019-01-07 12:30:00	SPY	ETF	255.26	255.67	255.11	255.46	4497750.0
2019-01-07 13:00:00	SPY	ETF	255.47	255.95	255.45	255.68	3736675.0
2019-01-07 13:30:00	SPY	ETF	255.68	255.84	254.75	254.84	5369990.0
2019-01-07 14:00:00	SPY	ETF	254.84	255.13	254.52	254.67	5406171.0
2019-01-07 14:30:00	SPY	ETF	254.6679	254.855	253.93	254.075	4487503.0
2019-01-07 15:00:00	SPY	ETF	254.08	255.17	254.03	254.95	5153003.0
2019-01-07 15:30:00	SPY	ETF	254.95	255.05	254.07	254.29	16341916.0
2019-01-07 16:00:00	SPY	ETF	254.27	254.5	245.29	254.23	7508379.0
2019-01-07 16:30:00	SPY	ETF	254.23	254.65	254.22	254.6	402437.0
2019-01-07 17:00:00	SPY	ETF	254.57	254.59	254.48	254.48	73932.0
2019-01-07 17:30:00	SPY	ETF	254.54	254.57	254.38	254.52	36704.0
2019-01-07 18:00:00	SPY	ETF	254.57	254.69	254.2	254.46	64426.0
2019-01-07 18:30:00	SPY	ETF	254.46	254.64	254.29	254.35	642798.0
2019-01-07 19:00:00	SPY	ETF	254.35	254.73	254.33	254.68	39794.0
2019-01-07 19:30:00	SPY	ETF	254.69	255.04	254.69	255.0	56093.0
2019-01-07 04:00:00	QQQ	ETF	156.34	156.47	156.04	156.06	13092.0
2019-01-07 04:30:00	QQQ	ETF	156.03	156.1	155.91	156.0	12191.0
2019-01-07 05:00:00	QQQ	ETF	155.95	156.23	155.95	156.21	5550.0
2019-01-07 05:30:00	QQQ	ETF	156.2	156.2	155.92	156.16	9926.0
2019-01-07 06:00:00	QQQ	ETF	156.13	156.13	155.65	155.79	24854.0
2019-01-07 06:30:00	QQQ	ETF	155.77	156.01	155.6	155.92	24000.0
2019-01-07 07:00:00	QQQ	ETF	155.92	156.22	155.8	156.14	63802.0
2019-01-07 07:30:00	QQQ	ETF	156.15	156.43	156.02	156.33	115144.0
2019-01-07 08:00:00	QQQ	ETF	155.9	157.13	155.8499	156.29	197779.0
2019-01-07 08:30:00	QQQ	ETF	156.28	156.31	155.95	156.04	272757.0
2019-01-07 09:00:00	QQQ	ETF	156.04	156.59	156.03	156.53	785200.0
2019-01-07 09:30:00	QQQ	ETF	156.54	157.069	156.11	156.635	5934831.0
2019-01-07 10:00:00	QQQ	ETF	156.63	156.98	156.2	156.85	3284332.0
2019-01-07 10:30:00	QQQ	ETF	156.84	157.59	156.84	157.44	4101879.0
2019-01-07 11:00:00	QQQ	ETF	157.44	157.62	157.1	157.21	2671998.0
2019-01-07 11:30:00	QQQ	ETF	157.22	158.49	157.13	158.45	4044650.0
2019-01-07 12:00:00	QQQ	ETF	158.45	158.58	158.0873	158.4801	1955669.0
2019-01-07 12:30:00	QQQ	ETF	158.48	158.69	158.3216	158.57	1310496.0

> showing 50 of 18,045 rows — these rows as CSV

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