PREVIEW / etf_30min / 2008-01-17

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-17.parquet
  size:    164 KB
  rows:    5,876

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-17 04:30:00	SPY	ETF	137.65	137.65	137.65	137.65	1000.0
2008-01-17 05:30:00	SPY	ETF	137.8	137.8	137.8	137.8	1000.0
2008-01-17 06:00:00	SPY	ETF	137.53	137.61	137.53	137.61	9000.0
2008-01-17 06:30:00	SPY	ETF	137.68	137.71	137.52	137.52	76000.0
2008-01-17 07:00:00	SPY	ETF	137.57	137.6	136.33	136.62	518200.0
2008-01-17 07:30:00	SPY	ETF	136.63	137.02	136.44	136.91	1103600.0
2008-01-17 08:00:00	SPY	ETF	136.94	137.4	136.44	136.67	5209300.0
2008-01-17 08:30:00	SPY	ETF	136.67	137.96	136.5	137.89	10351600.0
2008-01-17 09:00:00	SPY	ETF	137.89	138.0	137.57	137.58	3130241.0
2008-01-17 09:30:00	SPY	ETF	137.57	137.88	137.06	137.58	30489043.0
2008-01-17 10:00:00	SPY	ETF	137.57	137.58	135.7	136.02	47870968.0
2008-01-17 10:30:00	SPY	ETF	136.02	137.2162	135.29	135.97	30363827.0
2008-01-17 11:00:00	SPY	ETF	135.97	136.41	135.54	135.7	16497042.0
2008-01-17 11:30:00	SPY	ETF	135.71	135.9019	134.98	135.03	22559507.0
2008-01-17 12:00:00	SPY	ETF	135.03	137.0	134.5	135.02	18834921.0
2008-01-17 12:30:00	SPY	ETF	135.02	135.42	134.95	135.1	21727495.0
2008-01-17 13:00:00	SPY	ETF	135.09	135.62	134.73	135.35	16431753.0
2008-01-17 13:30:00	SPY	ETF	135.33	135.75	134.99	135.16	16975677.0
2008-01-17 14:00:00	SPY	ETF	135.16	135.29	134.31	134.32	20170451.0
2008-01-17 14:30:00	SPY	ETF	134.33	135.06	133.95	134.59	30746322.0
2008-01-17 15:00:00	SPY	ETF	134.57	135.02	133.63	133.64	29884753.0
2008-01-17 15:30:00	SPY	ETF	133.64	137.2162	132.93	133.23	48314964.0
2008-01-17 16:00:00	SPY	ETF	133.3	137.23	133.09	133.56	7714500.0
2008-01-17 16:30:00	SPY	ETF	133.6	134.36	133.14	133.77	6564000.0
2008-01-17 17:00:00	SPY	ETF	133.77	133.85	133.72	133.77	2233600.0
2008-01-17 17:30:00	SPY	ETF	133.77	133.8	133.64	133.66	106100.0
2008-01-17 18:00:00	SPY	ETF	133.73	134.06	133.65	133.98	278900.0
2008-01-17 18:30:00	SPY	ETF	134.0	134.17	133.97	134.03	53400.0
2008-01-17 19:00:00	SPY	ETF	134.02	134.04	133.9	133.92	39300.0
2008-01-17 19:30:00	SPY	ETF	133.98	134.14	133.95	134.06	67600.0
2008-01-17 04:00:00	QQQ	ETF	46.28	46.28	46.28	46.28	200.0
2008-01-17 05:30:00	QQQ	ETF	46.3	46.33	46.3	46.33	300.0
2008-01-17 06:00:00	QQQ	ETF	46.3	46.33	46.3	46.33	40400.0
2008-01-17 06:30:00	QQQ	ETF	46.29	46.29	46.29	46.29	4000.0
2008-01-17 07:00:00	QQQ	ETF	46.24	46.27	45.95	46.02	678049.0
2008-01-17 07:30:00	QQQ	ETF	45.99	46.16	45.94	46.15	482822.0
2008-01-17 08:00:00	QQQ	ETF	46.14	46.29	46.01	46.05	2054763.0
2008-01-17 08:30:00	QQQ	ETF	46.04	46.48	45.98	46.44	3648710.0
2008-01-17 09:00:00	QQQ	ETF	46.44	46.54	46.25	46.26	1465835.0
2008-01-17 09:30:00	QQQ	ETF	46.26	46.58	46.22	46.49	19939312.0
2008-01-17 10:00:00	QQQ	ETF	46.4805	46.49	45.83	46.04	34732701.0
2008-01-17 10:30:00	QQQ	ETF	46.04	46.12	45.63	45.99	26940370.0
2008-01-17 11:00:00	QQQ	ETF	45.99	46.24	45.94	46.04	12600505.0
2008-01-17 11:30:00	QQQ	ETF	46.04	46.11	45.73	45.76	11207628.0
2008-01-17 12:00:00	QQQ	ETF	45.75	45.82	45.49	45.82	16621110.0
2008-01-17 12:30:00	QQQ	ETF	45.82	46.03	45.74	45.84	14017240.0
2008-01-17 13:00:00	QQQ	ETF	45.83	46.04	45.65	45.93	9039281.0
2008-01-17 13:30:00	QQQ	ETF	45.92	46.17	45.79	45.88	15066166.0
2008-01-17 14:00:00	QQQ	ETF	45.9	45.96	45.53	45.56	10849028.0
2008-01-17 14:30:00	QQQ	ETF	45.5599	45.77	45.46	45.68	17378206.0

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

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