PREVIEW / etf_30min / 2019-01-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-11.parquet
  size:    487 KB
  rows:    16,947

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-11 04:00:00	SPY	ETF	258.94	259.0	258.84	258.99	21894.0
2019-01-11 04:30:00	SPY	ETF	259.0	259.03	258.66	258.83	26448.0
2019-01-11 05:00:00	SPY	ETF	258.75	258.83	258.47	258.49	11857.0
2019-01-11 05:30:00	SPY	ETF	258.49	258.7	258.16	258.44	16679.0
2019-01-11 06:00:00	SPY	ETF	258.45	258.59	258.24	258.3	14245.0
2019-01-11 06:30:00	SPY	ETF	258.33	258.47	258.16	258.17	9450.0
2019-01-11 07:00:00	SPY	ETF	258.29	258.29	258.0	258.23	94772.0
2019-01-11 07:30:00	SPY	ETF	258.18	258.36	258.05	258.05	41519.0
2019-01-11 08:00:00	SPY	ETF	258.05	258.8	257.69	257.87	158087.0
2019-01-11 08:30:00	SPY	ETF	257.95	258.17	257.59	257.87	325865.0
2019-01-11 09:00:00	SPY	ETF	257.84	258.02	257.55	257.68	248728.0
2019-01-11 09:30:00	SPY	ETF	257.68	257.86	257.03	257.54	7572456.0
2019-01-11 10:00:00	SPY	ETF	257.54	258.07	257.2	257.2152	4915887.0
2019-01-11 10:30:00	SPY	ETF	257.22	258.17	257.07	258.14	8774217.0
2019-01-11 11:00:00	SPY	ETF	258.15	258.27	257.58	257.99	4654977.0
2019-01-11 11:30:00	SPY	ETF	258.01	258.49	257.92	258.44	3229635.0
2019-01-11 12:00:00	SPY	ETF	258.43	258.65	258.24	258.459	2834218.0
2019-01-11 12:30:00	SPY	ETF	258.4514	258.91	258.42	258.74	3064627.0
2019-01-11 13:00:00	SPY	ETF	258.74	258.76	257.87	258.12	4105728.0
2019-01-11 13:30:00	SPY	ETF	258.13	258.49	258.02	258.33	3405005.0
2019-01-11 14:00:00	SPY	ETF	258.33	258.65	258.1215	258.55	2440336.0
2019-01-11 14:30:00	SPY	ETF	258.56	259.0098	258.2	258.265	4410142.0
2019-01-11 15:00:00	SPY	ETF	258.26	258.66	258.2	258.2718	3143113.0
2019-01-11 15:30:00	SPY	ETF	258.28	258.98	258.27	258.91	9539846.0
2019-01-11 16:00:00	SPY	ETF	258.91	258.99	258.75	258.76	7891605.0
2019-01-11 16:30:00	SPY	ETF	258.79	258.98	258.75	258.88	201475.0
2019-01-11 17:00:00	SPY	ETF	258.83	258.89	258.78	258.81	49462.0
2019-01-11 17:30:00	SPY	ETF	258.82	258.98	258.66	258.68	135365.0
2019-01-11 18:00:00	SPY	ETF	258.69	258.7	258.63	258.7	9440.0
2019-01-11 18:30:00	SPY	ETF	258.67	258.79	258.67	258.77	3225.0
2019-01-11 19:00:00	SPY	ETF	258.76	258.82	258.71	258.75	964482.0
2019-01-11 19:30:00	SPY	ETF	258.75	258.78	258.72	258.74	8003.0
2019-01-11 04:00:00	QQQ	ETF	161.15	161.22	161.08	161.18	4676.0
2019-01-11 04:30:00	QQQ	ETF	161.16	161.17	160.94	161.04	17350.0
2019-01-11 05:00:00	QQQ	ETF	161.04	161.04	160.87	160.87	3769.0
2019-01-11 05:30:00	QQQ	ETF	160.84	160.98	160.64	160.9	11200.0
2019-01-11 06:00:00	QQQ	ETF	160.8	160.92	160.68	160.71	15437.0
2019-01-11 06:30:00	QQQ	ETF	160.7	160.78	160.57	160.57	6321.0
2019-01-11 07:00:00	QQQ	ETF	160.69	160.69	160.47	160.69	36152.0
2019-01-11 07:30:00	QQQ	ETF	160.63	160.74	160.47	160.47	53341.0
2019-01-11 08:00:00	QQQ	ETF	160.46	161.05	160.2601	160.4	166778.0
2019-01-11 08:30:00	QQQ	ETF	160.44	160.58	160.21	160.43	266031.0
2019-01-11 09:00:00	QQQ	ETF	160.37	160.51	160.28	160.33	142585.0
2019-01-11 09:30:00	QQQ	ETF	160.32	160.47	159.79	160.19	3678899.0
2019-01-11 10:00:00	QQQ	ETF	160.19	160.6199	159.86	159.86	1994634.0
2019-01-11 10:30:00	QQQ	ETF	159.88	160.575	159.8	160.51	1930672.0
2019-01-11 11:00:00	QQQ	ETF	160.51	160.6	159.99	160.12	1379991.0
2019-01-11 11:30:00	QQQ	ETF	160.12	160.55	160.06	160.465	1367648.0
2019-01-11 12:00:00	QQQ	ETF	160.46	160.66	160.37	160.6	1129410.0
2019-01-11 12:30:00	QQQ	ETF	160.6	160.84	160.5686	160.69	1031257.0

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

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