PREVIEW / etf_30min / 2007-01-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-25.parquet
  size:    101 KB
  rows:    3,429

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
2007-01-25 04:00:00	SPY	ETF	143.94	143.94	143.94	143.94	1400.0
2007-01-25 06:00:00	SPY	ETF	144.02	144.02	144.02	144.02	10000.0
2007-01-25 06:30:00	SPY	ETF	143.97	143.97	143.97	143.97	2500.0
2007-01-25 07:00:00	SPY	ETF	143.91	143.91	143.91	143.91	10000.0
2007-01-25 07:30:00	SPY	ETF	143.91	143.93	143.82	143.82	8600.0
2007-01-25 08:00:00	SPY	ETF	143.82	143.96	143.82	143.85	64000.0
2007-01-25 08:30:00	SPY	ETF	143.88	143.94	143.82	143.88	314400.0
2007-01-25 09:00:00	SPY	ETF	143.9	143.96	143.83	143.83	235100.0
2007-01-25 09:30:00	SPY	ETF	143.84	143.92	143.7	143.77	4441800.0
2007-01-25 10:00:00	SPY	ETF	143.77	143.8	143.53	143.59	3007100.0
2007-01-25 10:30:00	SPY	ETF	143.59	143.68	143.35	143.51	4017000.0
2007-01-25 11:00:00	SPY	ETF	143.52	143.61	143.46	143.47	1532200.0
2007-01-25 11:30:00	SPY	ETF	143.47	143.54	143.26	143.3	2518000.0
2007-01-25 12:00:00	SPY	ETF	143.3	143.31	143.0	143.06	5270300.0
2007-01-25 12:30:00	SPY	ETF	143.06	143.18	143.0	143.07	2250200.0
2007-01-25 13:00:00	SPY	ETF	143.08	143.15	142.99	143.14	2673400.0
2007-01-25 13:30:00	SPY	ETF	143.13	143.13	142.46	142.57	9713700.0
2007-01-25 14:00:00	SPY	ETF	142.57	142.87	142.01	142.4	10779600.0
2007-01-25 14:30:00	SPY	ETF	142.41	142.54	142.32	142.51	3888700.0
2007-01-25 15:00:00	SPY	ETF	142.51	142.88	142.14	142.32	5753600.0
2007-01-25 15:30:00	SPY	ETF	142.32	142.44	142.22	142.35	7919500.0
2007-01-25 16:00:00	SPY	ETF	142.34	143.0663	142.21	142.39	1118600.0
2007-01-25 16:30:00	SPY	ETF	142.4	142.41	142.25	142.25	518100.0
2007-01-25 17:00:00	SPY	ETF	142.28	142.3	142.24	142.24	62900.0
2007-01-25 17:30:00	SPY	ETF	142.22	142.3	142.22	142.22	37700.0
2007-01-25 18:00:00	SPY	ETF	142.33	142.34	142.32	142.34	18500.0
2007-01-25 18:30:00	SPY	ETF	142.31	142.38	142.31	142.32	1900.0
2007-01-25 19:00:00	SPY	ETF	142.3	142.3	142.3	142.3	500.0
2007-01-25 19:30:00	SPY	ETF	142.31	142.31	142.28	142.28	700.0
2007-01-25 04:00:00	QQQ	ETF	44.39	44.39	44.39	44.39	200.0
2007-01-25 07:00:00	QQQ	ETF	44.42	44.42	44.4	44.4	21000.0
2007-01-25 07:30:00	QQQ	ETF	44.39	44.4	44.31	44.33	397322.0
2007-01-25 08:00:00	QQQ	ETF	44.35	44.4	44.34	44.37	493071.0
2007-01-25 08:30:00	QQQ	ETF	44.36	44.41	44.35	44.39	386860.0
2007-01-25 09:00:00	QQQ	ETF	44.4	44.43	44.35	44.37	530872.0
2007-01-25 09:30:00	QQQ	ETF	44.37	44.47	44.3	44.41	11254900.0
2007-01-25 10:00:00	QQQ	ETF	44.41	44.42	44.09	44.14	18782400.0
2007-01-25 10:30:00	QQQ	ETF	44.14	44.27	44.02	44.18	13484900.0
2007-01-25 11:00:00	QQQ	ETF	44.17	44.23	44.15	44.16	6071300.0
2007-01-25 11:30:00	QQQ	ETF	44.16	44.2	44.04	44.06	7307900.0
2007-01-25 12:00:00	QQQ	ETF	44.06	44.09	43.9	43.93	11651000.0
2007-01-25 12:30:00	QQQ	ETF	43.92	44.01	43.91	43.98	9726600.0
2007-01-25 13:00:00	QQQ	ETF	43.99	44.06	43.93	44.02	6744500.0
2007-01-25 13:30:00	QQQ	ETF	44.01	44.02	43.76	43.76	11373800.0
2007-01-25 14:00:00	QQQ	ETF	43.76	43.8	43.65	43.71	12692900.0
2007-01-25 14:30:00	QQQ	ETF	43.71	43.78	43.69	43.77	5667900.0
2007-01-25 15:00:00	QQQ	ETF	43.76	43.76	43.58	43.69	14473700.0
2007-01-25 15:30:00	QQQ	ETF	43.69	43.73	43.63	43.69	12739900.0
2007-01-25 16:00:00	QQQ	ETF	43.69	43.86	43.65	43.81	5678806.0
2007-01-25 16:30:00	QQQ	ETF	43.81	44.2798	43.68	43.71	3803163.0

> showing 50 of 3,429 rows — these rows as CSV

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