PREVIEW / etf_30min / 2008-10-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-14.parquet
  size:    185 KB
  rows:    6,581

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-10-14 04:00:00	SPY	ETF	102.78	103.29	102.78	103.29	2100.0
2008-10-14 04:30:00	SPY	ETF	103.02	103.02	102.09	102.11	10400.0
2008-10-14 05:00:00	SPY	ETF	102.2	102.67	102.1	102.6	4800.0
2008-10-14 05:30:00	SPY	ETF	102.67	102.81	102.41	102.8	9700.0
2008-10-14 06:00:00	SPY	ETF	102.8	103.6	102.77	103.52	58600.0
2008-10-14 06:30:00	SPY	ETF	103.55	104.38	103.55	104.1	240548.0
2008-10-14 07:00:00	SPY	ETF	104.06	104.47	103.95	104.15	597785.0
2008-10-14 07:30:00	SPY	ETF	104.2	104.25	103.87	104.03	563831.0
2008-10-14 08:00:00	SPY	ETF	103.579	105.29	101.35	105.05	7940934.0
2008-10-14 08:30:00	SPY	ETF	105.05	106.18	102.25	104.96	9244678.0
2008-10-14 09:00:00	SPY	ETF	105.01	105.09	104.3	104.7	8164553.0
2008-10-14 09:30:00	SPY	ETF	104.7	105.53	101.35	101.36	81140003.0
2008-10-14 10:00:00	SPY	ETF	101.37	102.92	100.97	101.75	53731186.0
2008-10-14 10:30:00	SPY	ETF	101.75	102.08	99.12	100.62	41822978.0
2008-10-14 11:00:00	SPY	ETF	100.62	101.04	99.2	100.8	31707812.0
2008-10-14 11:30:00	SPY	ETF	100.79	101.65	100.54	100.95	21927739.0
2008-10-14 12:00:00	SPY	ETF	100.91	101.1	100.08	101.06	19695683.0
2008-10-14 12:30:00	SPY	ETF	101.05	101.87	100.78	100.98	14183966.0
2008-10-14 13:00:00	SPY	ETF	100.98	101.23	100.41	100.6899	14857830.0
2008-10-14 13:30:00	SPY	ETF	100.69	101.26	99.67	99.95	20643608.0
2008-10-14 14:00:00	SPY	ETF	99.95	101.6	98.0	99.27	52753744.0
2008-10-14 14:30:00	SPY	ETF	99.28	99.48	97.11	97.61	45357505.0
2008-10-14 15:00:00	SPY	ETF	97.61	99.66	97.33	99.66	42808790.0
2008-10-14 15:30:00	SPY	ETF	99.66	101.8	98.99	99.93	51651100.0
2008-10-14 16:00:00	SPY	ETF	99.93	102.2647	98.1	99.88	10406786.0
2008-10-14 16:30:00	SPY	ETF	99.99	100.43	99.85	100.42	2978333.0
2008-10-14 17:00:00	SPY	ETF	100.47	100.48	99.87	99.87	6988601.0
2008-10-14 17:30:00	SPY	ETF	99.81	104.19	99.81	99.87	5459510.0
2008-10-14 18:00:00	SPY	ETF	99.92	100.24	99.85	100.24	27259.0
2008-10-14 18:30:00	SPY	ETF	100.2	100.2	99.8	99.89	106463.0
2008-10-14 19:00:00	SPY	ETF	99.9	99.92	97.57	98.42	124122.0
2008-10-14 19:30:00	SPY	ETF	98.79	98.79	98.12	98.68	110308.0
2008-10-14 04:00:00	QQQ	ETF	36.12	36.12	36.12	36.12	2000.0
2008-10-14 04:30:00	QQQ	ETF	36.01	36.01	35.95	35.95	3000.0
2008-10-14 05:00:00	QQQ	ETF	35.98	36.08	35.98	36.05	4600.0
2008-10-14 05:30:00	QQQ	ETF	36.07	36.07	36.01	36.01	600.0
2008-10-14 06:00:00	QQQ	ETF	36.02	36.25	36.02	36.25	19150.0
2008-10-14 06:30:00	QQQ	ETF	36.32	36.49	36.25	36.36	57914.0
2008-10-14 07:00:00	QQQ	ETF	36.47	36.6	36.34	36.45	191161.0
2008-10-14 07:30:00	QQQ	ETF	36.45	36.5	36.32	36.46	589916.0
2008-10-14 08:00:00	QQQ	ETF	36.46	36.62	36.27	36.52	2892059.0
2008-10-14 08:30:00	QQQ	ETF	36.52	36.7	36.35	36.36	3256066.0
2008-10-14 09:00:00	QQQ	ETF	36.37	36.37	36.01	36.08	4013178.0
2008-10-14 09:30:00	QQQ	ETF	36.1	36.15	34.5	34.5	51888007.0
2008-10-14 10:00:00	QQQ	ETF	34.51	35.05	34.42	34.84	38713770.0
2008-10-14 10:30:00	QQQ	ETF	34.85	34.97	33.96	34.47	31708745.0
2008-10-14 11:00:00	QQQ	ETF	34.47	34.49	33.87	34.4	21500655.0
2008-10-14 11:30:00	QQQ	ETF	34.39	34.83	34.25	34.56	15220887.0
2008-10-14 12:00:00	QQQ	ETF	34.56	34.66	34.26	34.66	10445359.0
2008-10-14 12:30:00	QQQ	ETF	34.6693	34.93	34.53	34.53	9843183.0

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

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