PREVIEW / etf_30min / 2009-11-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-30.parquet
  size:    236 KB
  rows:    7,786

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
2009-11-30 04:00:00	SPY	ETF	109.67	109.67	109.67	109.67	2000.0
2009-11-30 04:30:00	SPY	ETF	109.57	109.57	109.22	109.22	3500.0
2009-11-30 05:00:00	SPY	ETF	109.22	109.32	109.22	109.32	2000.0
2009-11-30 05:30:00	SPY	ETF	109.42	109.54	109.42	109.5	1574.0
2009-11-30 06:00:00	SPY	ETF	109.42	109.42	109.0	109.25	17766.0
2009-11-30 06:30:00	SPY	ETF	109.19	109.37	109.12	109.35	40800.0
2009-11-30 07:00:00	SPY	ETF	109.3	109.37	109.12	109.12	200558.0
2009-11-30 07:30:00	SPY	ETF	109.13	109.51	109.1	109.51	609696.0
2009-11-30 08:00:00	SPY	ETF	109.48	109.75	109.22	109.75	1235553.0
2009-11-30 08:30:00	SPY	ETF	109.73	109.81	109.53	109.55	751699.0
2009-11-30 09:00:00	SPY	ETF	109.56	110.2	109.12	109.48	1213825.0
2009-11-30 09:30:00	SPY	ETF	109.48	109.78	109.17	109.61	26890615.0
2009-11-30 10:00:00	SPY	ETF	109.61	110.04	109.59	110.01	11258240.0
2009-11-30 10:30:00	SPY	ETF	110.02	110.15	109.66	109.73	9122431.0
2009-11-30 11:00:00	SPY	ETF	109.73	109.73	109.21	109.26	10820178.0
2009-11-30 11:30:00	SPY	ETF	109.26	109.28	109.02	109.14	11372495.0
2009-11-30 12:00:00	SPY	ETF	109.14	110.2	109.12	109.34	5676793.0
2009-11-30 12:30:00	SPY	ETF	109.33	109.36	109.07	109.12	5899094.0
2009-11-30 13:00:00	SPY	ETF	109.13	109.37	109.09	109.35	4679985.0
2009-11-30 13:30:00	SPY	ETF	109.36	110.05	109.21	109.49	9136963.0
2009-11-30 14:00:00	SPY	ETF	109.5	109.53	109.35	109.43	5766815.0
2009-11-30 14:30:00	SPY	ETF	109.43	109.48	109.28	109.33	4673616.0
2009-11-30 15:00:00	SPY	ETF	109.33	109.82	109.33	109.75	12369035.0
2009-11-30 15:30:00	SPY	ETF	109.75	110.14	109.66	109.97	24545395.0
2009-11-30 16:00:00	SPY	ETF	109.97	110.08	109.1238	109.75	7384879.0
2009-11-30 16:30:00	SPY	ETF	109.76	109.84	109.5555	109.84	1671009.0
2009-11-30 17:00:00	SPY	ETF	109.85	109.86	109.74	109.74	173337.0
2009-11-30 17:30:00	SPY	ETF	109.77	109.8	109.7	109.76	45010.0
2009-11-30 18:00:00	SPY	ETF	109.78	109.78	109.73	109.77	26600.0
2009-11-30 18:30:00	SPY	ETF	109.78	109.85	109.77	109.79	98115.0
2009-11-30 19:00:00	SPY	ETF	109.75	109.92	109.74	109.91	26449.0
2009-11-30 19:30:00	SPY	ETF	109.9	110.01	109.82	109.84	61208.0
2009-11-30 05:00:00	QQQ	ETF	43.25	43.25	43.19	43.19	600.0
2009-11-30 05:30:00	QQQ	ETF	43.33	43.35	43.33	43.35	200.0
2009-11-30 06:00:00	QQQ	ETF	43.3	43.36	43.18	43.18	400.0
2009-11-30 06:30:00	QQQ	ETF	43.27	43.27	43.27	43.27	200.0
2009-11-30 07:00:00	QQQ	ETF	43.24	43.34	43.24	43.28	389378.0
2009-11-30 07:30:00	QQQ	ETF	43.28	43.38	43.26	43.38	96175.0
2009-11-30 08:00:00	QQQ	ETF	43.39	43.47	43.31	43.47	397213.0
2009-11-30 08:30:00	QQQ	ETF	43.47	43.49	43.41	43.41	562848.0
2009-11-30 09:00:00	QQQ	ETF	43.41	43.42	43.33	43.41	968158.0
2009-11-30 09:30:00	QQQ	ETF	43.41	43.48	43.24	43.395	14426108.0
2009-11-30 10:00:00	QQQ	ETF	43.39	43.59	43.39	43.56	7098805.0
2009-11-30 10:30:00	QQQ	ETF	43.56	43.62	43.405	43.4105	3999050.0
2009-11-30 11:00:00	QQQ	ETF	43.42	43.42	43.2	43.22	4992061.0
2009-11-30 11:30:00	QQQ	ETF	43.22	43.23	43.11	43.19	5266904.0
2009-11-30 12:00:00	QQQ	ETF	43.18	43.3	43.18	43.2899	3497043.0
2009-11-30 12:30:00	QQQ	ETF	43.29	43.29	43.2	43.21	3089688.0
2009-11-30 13:00:00	QQQ	ETF	43.205	43.29	43.19	43.29	1900386.0
2009-11-30 13:30:00	QQQ	ETF	43.29	43.39	43.24	43.3599	5788567.0

> showing 50 of 7,786 rows — these rows as CSV

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