PREVIEW / etf_30min / 2008-11-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-07.parquet
  size:    174 KB
  rows:    6,245

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
2008-11-07 04:00:00	SPY	ETF	92.56	92.59	92.35	92.35	10100.0
2008-11-07 04:30:00	SPY	ETF	92.4	92.4	92.21	92.21	1400.0
2008-11-07 05:00:00	SPY	ETF	92.26	92.45	92.23	92.43	5300.0
2008-11-07 05:30:00	SPY	ETF	92.51	92.69	92.39	92.64	4000.0
2008-11-07 06:00:00	SPY	ETF	92.6	92.6	92.1	92.24	113600.0
2008-11-07 06:30:00	SPY	ETF	92.37	92.4	91.73	91.91	184307.0
2008-11-07 07:00:00	SPY	ETF	91.91	91.92	91.45	91.72	771271.0
2008-11-07 07:30:00	SPY	ETF	91.79	92.05	91.56	91.65	735927.0
2008-11-07 08:00:00	SPY	ETF	91.76	92.75	91.45	91.93	3589581.0
2008-11-07 08:30:00	SPY	ETF	91.68	91.83	90.6	90.68	13509575.0
2008-11-07 09:00:00	SPY	ETF	90.69	91.6	90.5	91.6	5163276.0
2008-11-07 09:30:00	SPY	ETF	91.65	92.0	90.86	91.29	37811731.0
2008-11-07 10:00:00	SPY	ETF	91.3	93.39	91.29	92.62	39017501.0
2008-11-07 10:30:00	SPY	ETF	92.61	93.26	92.43	92.54	26345954.0
2008-11-07 11:00:00	SPY	ETF	92.54	92.69	91.5	91.66	29517557.0
2008-11-07 11:30:00	SPY	ETF	91.68	92.58	91.45	92.55	23315075.0
2008-11-07 12:00:00	SPY	ETF	92.56	92.91	92.11	92.27	13054146.0
2008-11-07 12:30:00	SPY	ETF	92.27	92.75	91.96	92.6	12652996.0
2008-11-07 13:00:00	SPY	ETF	92.6	92.84	92.25	92.68	11268313.0
2008-11-07 13:30:00	SPY	ETF	92.67	92.76	92.12	92.68	11257271.0
2008-11-07 14:00:00	SPY	ETF	92.68	92.77	92.25	92.43	12341472.0
2008-11-07 14:30:00	SPY	ETF	92.44	93.28	91.65	91.76	34988982.0
2008-11-07 15:00:00	SPY	ETF	91.76	92.36	91.13	91.5298	39027519.0
2008-11-07 15:30:00	SPY	ETF	91.53	93.41	91.38	93.21	43097040.0
2008-11-07 16:00:00	SPY	ETF	93.19	94.04	92.7	93.79	11660846.0
2008-11-07 16:30:00	SPY	ETF	93.8	93.93	93.72	93.8	8203050.0
2008-11-07 17:00:00	SPY	ETF	93.78	94.05	90.7	94.01	2217679.0
2008-11-07 17:30:00	SPY	ETF	94.04	94.11	93.7	93.77	101475.0
2008-11-07 18:00:00	SPY	ETF	93.77	94.2	93.77	94.2	56371.0
2008-11-07 18:30:00	SPY	ETF	94.25	94.74	94.17	94.6	83045.0
2008-11-07 19:00:00	SPY	ETF	94.44	94.51	94.3	94.3	19007.0
2008-11-07 19:30:00	SPY	ETF	94.32	94.33	94.16	94.16	23872.0
2008-11-07 04:00:00	QQQ	ETF	31.07	31.07	31.05	31.05	2200.0
2008-11-07 04:30:00	QQQ	ETF	31.09	31.09	31.04	31.04	2200.0
2008-11-07 05:00:00	QQQ	ETF	31.07	31.11	31.06	31.11	300.0
2008-11-07 05:30:00	QQQ	ETF	31.15	31.26	31.15	31.26	11200.0
2008-11-07 06:00:00	QQQ	ETF	31.22	31.22	31.22	31.22	400.0
2008-11-07 06:30:00	QQQ	ETF	31.22	31.28	31.15	31.15	2200.0
2008-11-07 07:00:00	QQQ	ETF	31.15	31.15	31.02	31.06	111405.0
2008-11-07 07:30:00	QQQ	ETF	31.08	31.14	31.02	31.06	374872.0
2008-11-07 08:00:00	QQQ	ETF	31.05	31.15	30.9	31.08	1986895.0
2008-11-07 08:30:00	QQQ	ETF	30.88	31.07	30.69	30.71	4065395.0
2008-11-07 09:00:00	QQQ	ETF	30.71	30.99	30.66	30.93	2095855.0
2008-11-07 09:30:00	QQQ	ETF	30.92	31.07	30.59	30.8	23624508.0
2008-11-07 10:00:00	QQQ	ETF	30.8	31.32	30.8	31.21	21007014.0
2008-11-07 10:30:00	QQQ	ETF	31.21	31.48	31.16	31.23	11805834.0
2008-11-07 11:00:00	QQQ	ETF	31.24	31.27	30.86	30.93	15405677.0
2008-11-07 11:30:00	QQQ	ETF	30.93	31.23	30.865	31.2299	8704191.0
2008-11-07 12:00:00	QQQ	ETF	31.22	31.34	31.16	31.19	7292905.0
2008-11-07 12:30:00	QQQ	ETF	31.18	31.31	31.07	31.25	4233977.0

> showing 50 of 6,245 rows — these rows as CSV

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