PREVIEW / etf_30min / 2008-01-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-07.parquet
  size:    156 KB
  rows:    5,688

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-01-07 04:00:00	SPY	ETF	141.74	141.87	141.74	141.87	15000.0
2008-01-07 04:30:00	SPY	ETF	141.85	141.96	141.84	141.96	5500.0
2008-01-07 05:30:00	SPY	ETF	142.14	142.14	142.14	142.14	2000.0
2008-01-07 06:00:00	SPY	ETF	142.16	142.16	142.13	142.14	55000.0
2008-01-07 06:30:00	SPY	ETF	142.15	142.22	142.09	142.22	53900.0
2008-01-07 07:00:00	SPY	ETF	142.16	142.29	142.01	142.08	347000.0
2008-01-07 07:30:00	SPY	ETF	142.05	142.08	141.82	141.9	441700.0
2008-01-07 08:00:00	SPY	ETF	141.93	142.28	141.83	141.94	1189800.0
2008-01-07 08:30:00	SPY	ETF	141.95	142.11	141.94	141.99	564100.0
2008-01-07 09:00:00	SPY	ETF	141.99	142.05	141.74	141.82	556021.0
2008-01-07 09:30:00	SPY	ETF	141.81	142.05	141.34	141.69	19349078.0
2008-01-07 10:00:00	SPY	ETF	141.69	141.7	140.36	140.41	20647770.0
2008-01-07 10:30:00	SPY	ETF	140.41	140.93	140.1	140.65	19756138.0
2008-01-07 11:00:00	SPY	ETF	140.66	141.3	140.65	141.25	17873644.0
2008-01-07 11:30:00	SPY	ETF	141.24	141.9	141.15	141.6	16839651.0
2008-01-07 12:00:00	SPY	ETF	141.6	141.78	141.04	141.5901	12399172.0
2008-01-07 12:30:00	SPY	ETF	141.59	142.23	141.59	142.06	15495209.0
2008-01-07 13:00:00	SPY	ETF	142.05	142.19	141.7	141.85	7031625.0
2008-01-07 13:30:00	SPY	ETF	141.85	142.196	141.12	141.35	14846256.0
2008-01-07 14:00:00	SPY	ETF	141.35	141.48	140.66	140.84	22008776.0
2008-01-07 14:30:00	SPY	ETF	140.83	142.16	140.4	140.89	19916967.0
2008-01-07 15:00:00	SPY	ETF	140.89	141.11	140.46	140.65	10335907.0
2008-01-07 15:30:00	SPY	ETF	140.65	141.71	140.2	141.46	23256112.0
2008-01-07 16:00:00	SPY	ETF	141.5	141.68	141.055	141.27	5591600.0
2008-01-07 16:30:00	SPY	ETF	141.29	141.34	141.19	141.21	222100.0
2008-01-07 17:00:00	SPY	ETF	141.25	141.28	141.13	141.13	67200.0
2008-01-07 17:30:00	SPY	ETF	141.13	141.24	141.09	141.21	23800.0
2008-01-07 18:00:00	SPY	ETF	141.14	141.19	141.14	141.18	413600.0
2008-01-07 18:30:00	SPY	ETF	141.16	141.28	141.16	141.28	2700.0
2008-01-07 19:00:00	SPY	ETF	141.28	141.35	141.24	141.29	8700.0
2008-01-07 19:30:00	SPY	ETF	141.25	141.32	141.22	141.32	7600.0
2008-01-07 04:30:00	QQQ	ETF	48.62	48.62	48.62	48.62	100.0
2008-01-07 06:00:00	QQQ	ETF	48.63	48.63	48.62	48.62	5500.0
2008-01-07 06:30:00	QQQ	ETF	48.58	48.62	48.58	48.62	51200.0
2008-01-07 07:00:00	QQQ	ETF	48.6	48.68	48.58	48.6	324072.0
2008-01-07 07:30:00	QQQ	ETF	48.59	48.59	48.46	48.53	358784.0
2008-01-07 08:00:00	QQQ	ETF	48.52	48.61	48.5	48.56	514332.0
2008-01-07 08:30:00	QQQ	ETF	48.55	48.59	48.47	48.52	832453.0
2008-01-07 09:00:00	QQQ	ETF	48.51	48.52	48.37	48.42	909526.0
2008-01-07 09:30:00	QQQ	ETF	48.41	48.56	48.2	48.45	22748895.0
2008-01-07 10:00:00	QQQ	ETF	48.4505	48.4505	47.69	47.74	24072675.0
2008-01-07 10:30:00	QQQ	ETF	47.74	48.68	47.43	47.77	23557425.0
2008-01-07 11:00:00	QQQ	ETF	47.77	48.23	47.77	48.08	19495051.0
2008-01-07 11:30:00	QQQ	ETF	48.07	48.55	48.04	48.3701	15707525.0
2008-01-07 12:00:00	QQQ	ETF	48.37	48.48	48.05	48.42	18754289.0
2008-01-07 12:30:00	QQQ	ETF	48.412	48.6	48.4	48.53	12080600.0
2008-01-07 13:00:00	QQQ	ETF	48.53	48.6	48.31	48.35	7069182.0
2008-01-07 13:30:00	QQQ	ETF	48.35	48.41	48.04	48.14	10507332.0
2008-01-07 14:00:00	QQQ	ETF	48.14	48.19	47.81	47.9	12250838.0
2008-01-07 14:30:00	QQQ	ETF	47.89	48.18	47.71	47.9272	12546627.0

> showing 50 of 5,688 rows — these rows as CSV

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