PREVIEW / etf_30min / 2009-07-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-17.parquet
  size:    215 KB
  rows:    7,167

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
2009-07-17 04:00:00	SPY	ETF	93.88	93.88	93.88	93.88	125.0
2009-07-17 04:30:00	SPY	ETF	94.11	94.13	94.11	94.13	200.0
2009-07-17 05:00:00	SPY	ETF	94.05	94.05	93.86	93.86	2800.0
2009-07-17 05:30:00	SPY	ETF	93.9	93.93	93.9	93.93	4500.0
2009-07-17 06:00:00	SPY	ETF	93.98	94.12	93.92	94.12	12500.0
2009-07-17 06:30:00	SPY	ETF	94.05	94.11	93.91	93.97	17700.0
2009-07-17 07:00:00	SPY	ETF	93.97	94.04	93.61	93.61	155527.0
2009-07-17 07:30:00	SPY	ETF	93.61	93.63	93.36	93.51	378147.0
2009-07-17 08:00:00	SPY	ETF	93.52	93.854	93.28	93.49	2022868.0
2009-07-17 08:30:00	SPY	ETF	93.49	93.83	93.45	93.82	1659788.0
2009-07-17 09:00:00	SPY	ETF	93.83	94.12	93.82	94.06	1960541.0
2009-07-17 09:30:00	SPY	ETF	94.06	94.1	93.54	93.83	17204817.0
2009-07-17 10:00:00	SPY	ETF	93.8399	94.07	93.67	94.05	14234271.0
2009-07-17 10:30:00	SPY	ETF	94.04	94.15	93.76	93.78	11561785.0
2009-07-17 11:00:00	SPY	ETF	93.78	93.89	93.66	93.85	6442416.0
2009-07-17 11:30:00	SPY	ETF	93.86	93.865	93.64	93.7	5245200.0
2009-07-17 12:00:00	SPY	ETF	93.7	94.04	93.69	93.8699	7036337.0
2009-07-17 12:30:00	SPY	ETF	93.87	94.01	93.79	93.89	7343781.0
2009-07-17 13:00:00	SPY	ETF	93.9	94.06	93.84	94.02	4327737.0
2009-07-17 13:30:00	SPY	ETF	94.025	94.32	94.02	94.1302	11798132.0
2009-07-17 14:00:00	SPY	ETF	94.14	94.17	93.97	94.082	6431940.0
2009-07-17 14:30:00	SPY	ETF	94.09	94.16	93.99	94.05	6420637.0
2009-07-17 15:00:00	SPY	ETF	94.042	94.12	93.91	93.94	6116065.0
2009-07-17 15:30:00	SPY	ETF	93.94	94.15	93.74	94.13	20003055.0
2009-07-17 16:00:00	SPY	ETF	94.13	94.18	93.7	94.17	6435011.0
2009-07-17 16:30:00	SPY	ETF	94.17	94.25	94.15	94.2	214101.0
2009-07-17 17:00:00	SPY	ETF	94.2	94.24	94.17	94.2	54328.0
2009-07-17 17:30:00	SPY	ETF	94.2	94.21	94.18	94.21	59310.0
2009-07-17 18:00:00	SPY	ETF	94.18	94.18	94.14	94.15	31620.0
2009-07-17 18:30:00	SPY	ETF	94.14	94.14	94.12	94.12	9037.0
2009-07-17 19:00:00	SPY	ETF	94.13	94.14	94.1	94.12	28500.0
2009-07-17 19:30:00	SPY	ETF	94.12	94.17	94.12	94.17	10606.0
2009-07-17 04:00:00	QQQ	ETF	37.26	37.26	37.26	37.26	214.0
2009-07-17 05:30:00	QQQ	ETF	37.28	37.28	37.28	37.28	100.0
2009-07-17 06:00:00	QQQ	ETF	37.32	37.32	37.32	37.32	200.0
2009-07-17 06:30:00	QQQ	ETF	37.29	37.32	37.29	37.32	615.0
2009-07-17 07:00:00	QQQ	ETF	37.3	37.3	37.16	37.16	7615.0
2009-07-17 07:30:00	QQQ	ETF	37.16	37.17	37.08	37.14	267674.0
2009-07-17 08:00:00	QQQ	ETF	37.15	37.22	37.09	37.17	512396.0
2009-07-17 08:30:00	QQQ	ETF	37.17	37.27	37.14	37.27	865027.0
2009-07-17 09:00:00	QQQ	ETF	37.27	37.38	37.26	37.36	1303372.0
2009-07-17 09:30:00	QQQ	ETF	37.36	37.43	37.17	37.2601	15624019.0
2009-07-17 10:00:00	QQQ	ETF	37.27	37.38	37.17	37.37	9682210.0
2009-07-17 10:30:00	QQQ	ETF	37.37	37.45	37.3	37.31	10621334.0
2009-07-17 11:00:00	QQQ	ETF	37.31	37.3802	37.25	37.37	7422808.0
2009-07-17 11:30:00	QQQ	ETF	37.37	37.38	37.28	37.35	3900573.0
2009-07-17 12:00:00	QQQ	ETF	37.34	37.43	37.3399	37.39	3982058.0
2009-07-17 12:30:00	QQQ	ETF	37.39	37.44	37.37	37.41	4363180.0
2009-07-17 13:00:00	QQQ	ETF	37.41	37.5	37.398	37.48	5631447.0
2009-07-17 13:30:00	QQQ	ETF	37.49	37.57	37.48	37.5	6343727.0

> showing 50 of 7,167 rows — these rows as CSV

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